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(
-Connection Diff =
VAR diff = [Connection] - [Connection Last Month]
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?