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 ,
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?
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.
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
