Forum Discussion
Conditional Formatting for Negative Numbers Bar Chart
I have a set of Revenue and EBITDA numbers for Customers. EBITDA can be negative sometimes. How can I still show it as positive but with a different color (red) than a positive EBITDA (black)? I was ...
Hi, I saw this question today (I know its too late, but hoping it might help someone)
I created 3 measures to solve this
MEAS TOT PROFIT = SUM(Data[Profit])
MEAS PROFIT ABS = IF([MEAS TOT PROFIT]<0, ABS([MEAS TOT PROFIT]), [MEAS TOT PROFIT])
MEAS COLOR = ( IF(SUM(Data[Profit])<0, "RED","GREEN"))
Then created a Bar chart with MEAS PROFIT ABS in X asis and then, under Format Visual, Bars, Colors, Default color, I clicked on fx (conditional formatting) and there I selected that MEAS COLOR.
I am sure there might be a more simpler way to solve this. But for now, this is what I could do in 2 mins. Hope it helps.