Heatmap by Column values

[jack555]

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

[jack555]

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

[Pragati11]

HI @jack555 ,

So I created a table visual as follows:

No under the formatting settings --> Cell elements, I try to give different colors to all these columns:

Similarly, do it for other columns:

Is this what you are looking for?

[jack555]

@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.

[Pragati11]

Hi @jack555 ,

In that case, share the sample data which you are using to create this matrix visual.

[jack555]

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

[LeeMelbourne · Accepted solution]

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.

[jack555]

Yes, need to hard code every column. it is challenging if columns are dynamic. finally i gave up the.

[LeeMelbourne]

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