Forum Discussion
PowerBI Heatmap
Hi Team,
wondering if there is a way to create a heatmap based on a static list
For instance : we sell everything on the Master list and i want to easily see in that master
what my clients have Existing ( one colour)
what my clients have Proposed ( one colour)
All my data is one table and i can toggle by client- but cant figure out how to make the list change colour based on non values
Master list
Products: A/B/C/D/E/F
Client 1- uses B/E/F pitching they use A/D/C
Appreciate your thoughts and suggestions
Cheers
Kat
you can do heatmaps by using the same color for the text and the background for the values in a matrix visual. In Power Query or in DAX create a calculated column with the name of the colour you want for either existing or proposed (for example "Blue" or "#0000FF"). Then you can use the conditional formatting for the values in your matrix, based on "value in another field"
2 Replies
you can do heatmaps by using the same color for the text and the background for the values in a matrix visual. In Power Query or in DAX create a calculated column with the name of the colour you want for either existing or proposed (for example "Blue" or "#0000FF"). Then you can use the conditional formatting for the values in your matrix, based on "value in another field"
Hi Anonymous ,
For the detailed steps, please refer to https://www.tutorialgateway.org/heat-map-in-power-bi/#:~:text=To%20connect%20that%20matrix%20to,default%20color%20to%20the%20matrix.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
