Change column used in map depending if slicer is used

[SSMEMLE]

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 

• Country
• ZIP
• City
• Street

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 

Slicer used =

var _check = calculate(isfiltered(From[FromKey]) , allselected())

RETURN
IF _check then use table 'To'[Country], else use table 'False'[Country]

[SSMEMLE · Accepted 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 🙂 

[amitchandak]

@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