Latest Enterprise DNA Initiatives

Combining + & - Value measures in the same column in a table

I have a report that is comparing this month to last month and the desire is to format in green if positive and red if negative. The only way I currently know how to do this is to separate out the + and - values into two measures using an IF(
ex.
-Connection Diff =
VAR diff = [Connection] - [Connection Last Month]
RETURN
IF(diff <0, diff, BLANK())

This works great is a graph visual, but it lacks the ability to show up in a table in the same column to compare to the previous month. Does anyone know if this is possible?

@owen.grey,

Welcome to the forum - great to have you here!

You can address this requirement quite easily using conditional formatting. Here’s a video where @sam.mckay walks through exactly how to do this:

  • Brian
1 Like