Dynamic Heat Map

[djkoenig]

Hello Experts,

I've come up against a weird ask and I'm not enirely sure how to execute it. The request is to create an animated heat map that plays on a loop demonstrating the amount of Sales by Country. Ideally, the density/concentration of the "sales heat" will also slowly change as the loop plays.

So far, I have the map playing on a loop, but due to the nature of construction it flits around from country to country. You'll see if you open the link. For one, I'd prefer if the zoom stayed consistent. I figured a running total measure might help this issue, but that didn't seem to do it. Maybe's it's more doable if I did it in Python or something else....But, quite honestly, I am out of my depth and would appreciate a life preserver (or maybe a resuce helicopter).

Any opinion on the best way to accomplish this (or something similar) would be appreciated 🙂 

Data, of course, is made up and does represent anything meaningful.

Link to my report: https://drive.google.com/file/d/1cW0pOqxD_eIXZgkx3W16ruOMLQSLQ0sZ/view?usp=drive_link

Thanks!

[Anonymous]

Hi @djkoenig ,

If I understand correctly, this is what happens when the zoom changes? There are multiple regions with data for that day, so the zoom is applied to show all of them.

I created two additional calculated columns, please check the attachment to see if it meets your needs.

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[djkoenig]

Thanks for taking a stab at this @Anonymous! I think there might be a bit of a misunderstanding. 

I was trying to display the whole map, and then have the "sales heat" slowly get "hotter" as more sales are performed in the region. For example, if we had something like this (although it would be by month in my PBIX): 

Year	Country	Amount
2022	CN	10M
2022	US	12M
2022	SG	1M
2023	CN	8M
2023	US	10M
2023	SG	12M
2023	JP	4M

First, it would always show the whole map (i.e. map scale is fully zoomed out to a whole world view and never changes). Then, as the loop began to play, countries with sales in 2022 (or really respective month in 2022) would be lightly colored. In 2023 the density of the color would grow hotter/darker for the countries that already had sales, and a lightly colored sect would appear on Japan (JP). 

Hopefully that helps clarify and if not please ask me some more questions. 

1) Fully zoomed and locked axis

2) Heat change to denote increase in cumulative sales