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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors