Forum Discussion
Shape Map selection resets other Shape Map
Hi again GebauerAnalytic ,
To keep execs happy... This may work for you with less overhead.
Duplicate your filter table and create this as a look up table.
Extract the data for reporting to execs and create this as a stand a lone table.
I created an example and uploaded so you can trial if this is an option.
The sample data I found for USA is too large though so please filter when testing as required.
Note, Alasksa filters only right hand map and right hand table with data.
CLICKING STATE FILTERS ONLY UPDATES RIGHT HAND MAP
Cheers,
Maria
Hi GebauerAnalytic ,
Perhaps the community knows a better way, but I duplicated the map data and then used one table for the top visual with slicers from that table and the duplicated table for the bottom visual and slicers from the second table.
This may be too large an overhead for you data though. Not sure how many calcualtions you require, but it does allow independant display.
Cheers,
Maria
Data coming from 2 different tables - duplicated original table.
Yeah, displaying every single county on a Shape Map is already overtaxing Power BI's resources. I'm fairly certain the execs wouldn't put up with the lag time between clicks if I duplicated all datasets.
Hi again GebauerAnalytic ,
To keep execs happy... This may work for you with less overhead.
Duplicate your filter table and create this as a look up table.
Extract the data for reporting to execs and create this as a stand a lone table.
I created an example and uploaded so you can trial if this is an option.
The sample data I found for USA is too large though so please filter when testing as required.
Note, Alasksa filters only right hand map and right hand table with data.
CLICKING STATE FILTERS ONLY UPDATES RIGHT HAND MAP
Cheers,
Maria
