Forum Discussion

GebauerAnalytic's avatar
GebauerAnalytic
Frequent Visitor
7 years ago
Solved

Shape Map selection resets other Shape Map

I'm attempting to make a widget for sales executives to be able to carve up salespeople territories via county selection, and to that end, was putting two maps on one page in order for the executive ...
Need Help
  • MariaP's avatar
    MariaP
    7 years ago

    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.

     

    USA MAP PBIX TEST

     

    Note, Alasksa filters only right hand map and right hand table with data.

     

    CLICKING STATE FILTERS ONLY UPDATES RIGHT HAND MAP

     

    Cheers,
    Maria

     

GebauerAnalytic's avatar
GebauerAnalytic
Frequent Visitor
7 years ago

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. 

MariaP's avatar
MariaP
Solution Supplier
7 years ago

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.

 

USA MAP PBIX TEST

 

Note, Alasksa filters only right hand map and right hand table with data.

 

CLICKING STATE FILTERS ONLY UPDATES RIGHT HAND MAP

 

Cheers,
Maria