Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
94 | |
84 | |
32 | |
27 |