Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
myk83
Frequent Visitor

Focus behaviour in maps

<span class="lia-image-container-editor lia-image-container-align-inline lia-image-source-type-new" style="max-width: 525px;" contenteditable="false" data-mce-style="max-width: 525px;" data-lia-image-count="1" data-lia-image-id="12136i06775CAA76851163" data-lia-image-size="large" data-lia-image-width="525" data-lia-image-height="433" data-lia-image-alt="Map Section.JPG" data-lia-image-original_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/origina..." data-lia-image-small_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/small?v..." data-lia-image-medium_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/medium?..." data-lia-image-large_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v..." data-lia-image-align="inline" data-lia-image-src="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v..." data-lia-image-sourcetype="new" data-lia-image-macro="true"><img width="525" height="433" class="lia-image-display" src="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v..." border="0" data-mce-selected="1" data-mce-src="/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v=v2&amp;px=-1" data-lia-image-count="1"><i class="lia-fa lia-fa-pencil lia-image-edit-icon"></i></span>

Map Section.JPGThis will probably be either really simple or impossible, but I'm learning as I go with PowerBI so any advice is greatly appreciated!

 

I'm using a map visualisation for my data, mapping out values using postcodes to show the dots and some tables that show the detail of the data being mapped.  The data that I have is also grouped (or at least to me it is) by reference numbers, which may cover more than 1 postcode.  Currently, when I click on a postcode, it will focus the map on that dot, and only show the data for that dot in the table.

 

What I would like it to do is show the data for all of the groups that contain that location, as well as any other locations that the group contains, so it shows them on the map as well.  I've tried to include an image in case that helps:

 

<span class="lia-image-container-editor lia-image-container-align-inline lia-image-source-type-new" style="max-width: 525px;" contenteditable="false" data-mce-style="max-width: 525px;" data-lia-image-count="1" data-lia-image-id="12136i06775CAA76851163" data-lia-image-size="large" data-lia-image-width="525" data-lia-image-height="433" data-lia-image-alt="Map Section.JPG" data-lia-image-original_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/origina..." data-lia-image-small_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/small?v..." data-lia-image-medium_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/medium?..." data-lia-image-large_href="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v..." data-lia-image-align="inline" data-lia-image-src="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v..." data-lia-image-sourcetype="new" data-lia-image-macro="true"><img width="525" height="433" class="lia-image-display" src="https://community.powerbi.com/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v..." border="0" data-mce-selected="1" data-mce-src="/t5/image/serverpage/image-id/12136i06775CAA76851163/image-size/large?v=v2&amp;px=-1" data-lia-image-count="1"><i class="lia-fa lia-fa-pencil lia-image-edit-icon"></i></span>

1 ACCEPTED SOLUTION
v-ljerr-msft
Employee
Employee

@myk83

Currently, when I click on a postcode, it will focus the map on that dot, and only show the data for that dot in the table.

 

What I would like it to do is show the data for all of the groups that contain that location, as well as any other locations that the group contains, so it shows them on the map as well. 


Currently, it is not possible to change visualization interactions as you mentioned above in a Power BI report. 

 

By default, visualizations on a report page can be used to cross-filter and cross-highlight the other visualizations on the page. For example, selecting a state on a map visualization highlights the column chart and filters the line chart to display only data that applies to that one state.

We can change this default behavior. However, there are only three option to determine what impact the selected visualization should have on the others: filter, highlight, and no impact.

 

Reference:

Visualization interactions in a Power BI report

About filters and highlighting in Power BI reports

 

Regards

View solution in original post

1 REPLY 1
v-ljerr-msft
Employee
Employee

@myk83

Currently, when I click on a postcode, it will focus the map on that dot, and only show the data for that dot in the table.

 

What I would like it to do is show the data for all of the groups that contain that location, as well as any other locations that the group contains, so it shows them on the map as well. 


Currently, it is not possible to change visualization interactions as you mentioned above in a Power BI report. 

 

By default, visualizations on a report page can be used to cross-filter and cross-highlight the other visualizations on the page. For example, selecting a state on a map visualization highlights the column chart and filters the line chart to display only data that applies to that one state.

We can change this default behavior. However, there are only three option to determine what impact the selected visualization should have on the others: filter, highlight, and no impact.

 

Reference:

Visualization interactions in a Power BI report

About filters and highlighting in Power BI reports

 

Regards

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.