Forum Discussion
Heatmap using 'Filled Map' based on values
Anonymous You have used Sum of cars in the field value for rules. Replace it with your [% of Grand Total cars] measure. Because Sum of cars will yield whole numbers not percentages.
Thanks,
Jai
Anonymous The heatmap can be dynamically formatted by using a measure based on the slicer selection. In the below file I have categorized the countries ranging from < 20% as red, >30% as yellow and >40% as green. You can refer the measure and tweak your DAX accordingly. Attached the PBIX file here: Download PBIX
Did I answer your question ? If yes, please mark this post as a solution.
Thanks,
Jai
Hello Jai-Rathinavel thanks for that, I think I might just make it work. I am struggling with the rules. Can you see what am I doing wrong there?
I have a % of grand total for the cars - showed in a table and the rules, but the map does not show the right colours.
Anonymous You have used Sum of cars in the field value for rules. Replace it with your [% of Grand Total cars] measure. Because Sum of cars will yield whole numbers not percentages.
Thanks,
Jai