Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |