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.
Hi all,
I have a question. Below is a screenshot of my dummy data and final output that I want to achieve.
This data is about Average Population for ach Country.
Population by Age Range:
Final Output:
Note: Row 5 is the Average Population for each Country
I want to allow the data cell to change color based on the Average Population for each Country.
If it is lower, Green. If it is higher, Red.
As you can see that D2 is green because it is lower than the average (1.35).
My question is how should I come out with the logic so that the cell will change color for Matrix table.
Thanks and Regards!
Hi @Anonymous,
Unfortunately, this is not supported yet in current release desktop. Here are two similar ideas, you could click to vote it up:
Conditional formatting between two measure
conditional formatting intervals
Regards,
Yuliana Gu
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |