Forum Discussion
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 per column with different colour. Positive column with green colour heatmap by considering only the values in positive column.
| Item | Positvie | Negative | Neutral |
| Team 1 | 125 | 42 | 56 |
| Team 2 | 30 | 97 | 83 |
| Team 3 | 68 | 76 | 17 |
| Team 4 | 90 | 113 | 29 |
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.
8 Replies
Pragati11 Thanks for the input. The positive/negative/netural not available as separate columns but in the same column. sorry for not clear with my question. the sample data is the visual outcome of matrix, hence couldn't able to format individual column.
how we can acheive the same effect if rating items in same column.
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
