cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
myk83
Frequent Visitor

Focus behaviour in maps

 

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:

 

Map Section.JPG

 So in this picture, if I click on the right hand dot of the middle two (labelled "1"), it will focus on that dot and the table will only show the data for that dot.  But I would like it to also show the right hand dot (labelled "1 & 2") and have the table show me the data that is relevant to group 1.

 

I'm not sure I've explained this right, but hopefully there will be enough useful information for someone to either tell me it's not possible, or start me in the right direction!

 

Many thanks,

Mike

1 REPLY 1
Eric_Zhang
Microsoft
Microsoft

@myk83

 


@myk83 wrote:

 

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:

 

Map Section.JPG

 So in this picture, if I click on the right hand dot of the middle two (labelled "1"), it will focus on that dot and the table will only show the data for that dot.  But I would like it to also show the right hand dot (labelled "1 & 2") and have the table show me the data that is relevant to group 1.

 

I'm not sure I've explained this right, but hopefully there will be enough useful information for someone to either tell me it's not possible, or start me in the right direction!

 

Many thanks,

Mike


 

When clicking in the map, actually it is filttered by PostCode in your case. I don't think there's a way in Power BI desktop to achieved the bold part. However, you could filter the group by clicking a slicer. Check a demo in the attached pbix, that's all what PBI can do AFAIK. I don't know how you define a group, in whatever cases proper relationship should be created.

Capture.PNGCapture.PNG

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors