Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a matrix with months and numbers like in the image. I would like to turn it into a heatmap of four colours/options for 0-25% of the range. 25-50% of the range. 50%-75% of the range and finally 75-100% of the range of numbers in the matrix.
Is this possible via a measure?
Thanks
Solved! Go to Solution.
Click on matrix
click on format
click on cell elements
Turn on Background color
click on Fx
My value is not a percent, but PowerBI calculates the percent based on the row and context filter.
I can demonstrate this by adding another row to my Matrix that has a super high value:
Don't forget to mark as solution and give me a thumbs up if you found this helpful!
Click on matrix
click on format
click on cell elements
Turn on Background color
click on Fx
My value is not a percent, but PowerBI calculates the percent based on the row and context filter.
I can demonstrate this by adding another row to my Matrix that has a super high value:
Don't forget to mark as solution and give me a thumbs up if you found this helpful!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
95 | |
91 | |
82 | |
69 |
User | Count |
---|---|
161 | |
127 | |
124 | |
108 | |
97 |