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
Thank you for your help. The data I have will have a slicer too - so I can select all cars, but can also filter based on type: petrol, diesel etc. I think Fill Colours will only work on static numbers and will not show properly If i select different variations? Do I understand it right?
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