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.
<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&px=-1" data-lia-image-count="1"><i class="lia-fa lia-fa-pencil lia-image-edit-icon"></i></span>
This 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&px=-1" data-lia-image-count="1"><i class="lia-fa lia-fa-pencil lia-image-edit-icon"></i></span>
Solved! Go to Solution.
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
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
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |