Multiple Data Layers in ArcGIS map

[xyz9809]

Hi, 

I am trying to build a map visualizing how different types of water rates have changed over the last decade in the US. I tried two approaches for this:

1. since Power BI does not allow multiple data layers, I pivoted my data and used attributes to filter the layer data, however since the ranges of these rates are vastly different from each other, the color and size of the bubbles ended up following 1 scale and did not look correct.

2. I tried adding multiple layers on ArcGIS service and imported that to Power BI, however, these layers are all time enabled and I am not getting the option for a time slider when importing the layers from ArcGIS.

How do I fix this? What is the best approach in this case?

@lukaszp @v-jingzhang Please help

[Anonymous]

Hi, @xyz9809 
 It's been a while since we last interacted. Has your issue been resolved? If our answers did not solve your problem, please let us know the shortcomings of our solution.

If our answers have helped you, please accept the answer you found effective as the solution. This will help many community members with similar issues.

Of course, if you have your own solution, feel free to share it with us. Looking forward to your response, thank you in advance!

Best Regards,

Leroy Lu

[Anonymous]

Hi, @xyz9809 
Thanks for reaching out to the Microsoft fabric community forum.

Regarding the issue you raised, my solution is as follows:

1.First, regarding your initial question, you might consider clearing the reference scale. Below is a screenshot from the relevant documentation:

While reference scales are very useful when designing printed maps, you may want to disable this behaviour when using interactive and web maps. Typically, multi-scale web maps adjust symbol and text sizes for each map scale.

For more details, please refer to the documentation:

Symbol units and size—ArcGIS Pro | Documentation
Map reference scales—ArcGIS Pro | Documentation
 

2.Secondly, the time slider requires you to add a time field in the Time field well. Below is a screenshot from the relevant documentation:

For more details, please refer to the documentation:

Enable time animation—ArcGIS for Microsoft 365 | Documentation
 

I hope this information is helpful to you. If you have any other questions, feel free to let me know!
 

Best Regards,

Leroy Lu

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