Forum Discussion
Solved
Heatmap by Column values
Heatmaps can be easily done via conditional formatting, however it considers the whole matrix table. My requirement is to do by column. Below is the sample table, where I would like to have heatmap p...
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.
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.