Forum Discussion
Conditional Formatting for Negative Numbers Bar Chart
Hi Sang,
For more details about conditional formatting, please refer to:
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting.
Regards,
Jimmy Tao
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