Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So in my data I've got a fact table and 2 dimension 'From' and 'To'
The map visual uses the 'From'c data, and if you select one if the points on the map it will filter the other tables with the 'To' values.
Both these tables have the following columns used in the map
I've also got a slicer with key values from the 'From' table.
What we want to achieve is if the slicer is used, the map visual should use the data from the 'From' table instead of the 'To' table
Anyone has any idea on how to achieve this?
Ideally it would be something like
Solved! Go to Solution.
Hi @amitchandak
Thanks for writing this up and sharing it. I've learned something new today! Unfortunatly this would not help my use case as the slicer should only be 1 column (as is), it's really only the column/table that needs to be changed when using the slicer.
I think I'll try to use some kind of bookmark to solve it 🙂
Hi @amitchandak
Thanks for writing this up and sharing it. I've learned something new today! Unfortunatly this would not help my use case as the slicer should only be 1 column (as is), it's really only the column/table that needs to be changed when using the slicer.
I think I'll try to use some kind of bookmark to solve it 🙂
@SSMEMLE , Check if field parameter used in location can help
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
else you have to use bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |