Forum Discussion

djkoenig's avatar
djkoenig
Helper II
2 years ago

Dynamic Heat Map

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!



 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      djkoenig
      Helper II
      2 years ago

      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): 

      YearCountryAmount

      2022

      CN

      		10M

      2022

      		US12M
      2022SG1M
      2023CN8M

      2023

      		US10M

      2023

      		SG12M
      2023JP4M

       

      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