Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 able to show it as positive value by using Absolute function but not sure how to run conditional formatting to make it look red? A3 is the customer with negative data. Here is:
Hi, I saw this question today (I know its too late, but hoping it might help someone)
I created 3 measures to solve this
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.
You can do it if you go into Visualizations->Format->Data Colors.
Then if you hover a mouse in the top-right corner you'll see 3 dots. If you click on those, you'll see a CONDITIONAL FORMATTING tab. There you can select different colors for negative and positive bars.
Liking the OP in support of wishing for this functionality.
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..., color saturation can meet your requirement, in recent PBI version this feature seems to be deprecated.
Regards,
Jimmy Tao