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