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 there I feel I may the know the answer to this but thought I should ask anyway....I have created a matrix which I want to show as a heatmap for a risk report and want to show this as a heatmap based on a matrix. The problem I am having is that the colour of the cells is denoted by the row and column rather than the value in the cells.
So it would look something like this....
However everything I have looked into suggests that it could not be done. Is that truly the case?
Thanks,
Mike
It should be possible - you need to create a measure for formatting the colour of the cells (maybe something like impact value + likelihood value) and then use the format cells > background colour > fx and then format based on that measure, rather than the matrix value.
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 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |