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 ...
This won't work for two reasons:
1. I want it on the bar-chart as explained. I do not see conditional formatting option in a bar-chart.
2. I want a different color for the bar-chart if another measure is negative.
Hi Sang,
Based on my test, in clustered column chart you can change color of all values in a column, but I'm afraid changing part of values can't be achieved. You can submit your idea here:https://ideas.powerbi.com.
In addition, although in this thread (posted in 2016):https://community.powerbi.com/t5/Developer/Conditional-formatting-Change-of-chart-color-based-on-the-value/td-p/41263, color saturation can meet your requirement, in recent PBI version this feature seems to be deprecated.
Regards,
Jimmy Tao