Forum Discussion
Heatmap by Column values
So is there no answer to this?
Power BI Tabular Heatmap seems to be pretty poorly designed. You need to hard code every column?
That is not how a heatmap is supposed to work. A heatmap is the intersection between 2 dimensions, with a value expressing each intersection. So two dimensions and a measure should be required.
Hi jack555 ,
In that case, share the sample data which you are using to create this matrix visual.
Please find the sample data as below.
| Item | Rating |
| Team1 | Positive |
| Team1 | Positive |
| Team1 | Positive |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Negative |
| Team1 | Neutral |
| Team1 | Neutral |
| Team1 | Neutral |
| Team1 | Neutral |
| Team1 | Neutral |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Positive |
| Team2 | Negative |
| Team2 | Negative |
| Team2 | Negative |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
| Team2 | Neutral |
So is there no answer to this?
Power BI Tabular Heatmap seems to be pretty poorly designed. You need to hard code every column?
That is not how a heatmap is supposed to work. A heatmap is the intersection between 2 dimensions, with a value expressing each intersection. So two dimensions and a measure should be required.
Yes, need to hard code every column. it is challenging if columns are dynamic. finally i gave up the.
Hi there. After a bit more searching I found that one of the table visualisations can be used to derive this. You need to set conditional colors to make it work. You can see the results in this vid where i was making the dashboard. https://youtu.be/mMTcXaWdHbc?t=218