Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a slicer with individuals thorughout the country and the state they are assigned to.
How can I use the map to show the states associated with the selected individuals?
Solved! Go to Solution.
If the data is connected that should happen by default. If I filter anything that should filter related states.
Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.
Proud to be a Datanaut My Recent Blog -Time Intelligence - Direct Query
Put state into location and individual like the person on the legend. That would be too heavy but should work.
Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Thank you.
I have the legend and that accurately plots their assigned states on the map.
What I'm trying to do is have the slicer outside of the map drive their individual plotting. So when I choose John Smith not only does all of the other visuals show his assigned data but the map then shows his assigned states.
If the data is connected that should happen by default. If I filter anything that should filter related states.
Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.
Proud to be a Datanaut My Recent Blog -Time Intelligence - Direct Query
It works! Thank you very much!
You would put the State column into the Location area of the map visual. Hard to be more specific without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Depending on your data, you may want to set an appropriate Data category on your State column to give Power BI the heads up that it is a location.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |