cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ansa_naz Member
Member

Adding a measure to the tooltip for a Map visual stops the Funnel filters working??

Hi all

 

I currently have a map visual, which shows the location of various buildings we look after based on their Postcode as the location. I also have a Funnel visual to filter on engineer, for which engineer looks after the building:

 

Map with measure tooltip.jpgMap using a tooltip measureMap without measure tooltip.jpgMap without a tooltip measure

The first map visual shows what happens when I filter for engineer APhi using a map with the tooltip measure (measure calc shown at the top). The map visual does not filter its location data based on the selection of engineer APhi

 

 

 

 

 

 

 

 

 

 

The second map visual is NOT using the tooltip measure. When I filter for engineer APhi, the location data on the map is also filtered to only show locations looked after by APhi.

 

 

 

 

 

 

 

 

 

 

 

 

 

Is it possible to filter by engineer, using the tooltip measure for the Map visual, and have the map location data get filtered too? I tried using a Slicer visual instead of the Funnel visual for the engineer selection, but this does not work either when I use the tooltip measure

 

Map with tooltip measure - No filter applied.jpgMap using a tooltip measure with no Engineer filter appliedMap with tooltip measure - Filter applied.jpgMap using a tooltip measure with Engineer filter appliedI am guessing the tooltip measure is not quite right and maybe needs to be written differently. This is because when I use the tooltip measure with the Map visual, the tooltip shows the Site Name as long as the location data is not being filtered by engineer (see the third image).

 

 

 

 

 

 

 

 

As soon as I filter by engineer the tooltip stops showing the Site Name (see the fourth image)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

My tooltip measure is currently as follows:

 

Site-Name = 
 VAR ItemCount = DISTINCTCOUNT(ANSAContractLifts[SiteName])
 RETURN
 IF(ItemCount >= 3,
 CALCULATE(CONCATENATEX(TOPN(3,VALUES(ANSAContractLifts[SiteName])),
ANSAContractLifts[SiteName],", "))&" and more…", CALCULATE(CONCATENATEX(VALUES(ANSAContractLifts[SiteName]),
ANSAContractLifts[SiteName],", ")) )

Does anyone have any idea on what I can do with the tooltip measure, if that is the issue? I would really like to keep it if possible, as the Postcode by itself as a tooltip is not very useful. With the Site Name the tooltip is a LOT more useful

 

Cheers for all help

Naz

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Adding a measure to the tooltip for a Map visual stops the Funnel filters working??

Hi @ansa_naz,

 

Based on my test, when we check the value in Funnel chart to filter data in map, the measure placed in Map visual Tooltips property will not stop filtering. In my test, the above map contains measure in Tooltips property while the below map doesn't have. Please refer to screeshots below:

 

q1.PNGq2.PNGq3.PNG

 

In your scenario, please take a look at my tested .PBIX file then compare it with yours to find where is the issue.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Adding a measure to the tooltip for a Map visual stops the Funnel filters working??

Hi @ansa_naz,

 

Based on my test, when we check the value in Funnel chart to filter data in map, the measure placed in Map visual Tooltips property will not stop filtering. In my test, the above map contains measure in Tooltips property while the below map doesn't have. Please refer to screeshots below:

 

q1.PNGq2.PNGq3.PNG

 

In your scenario, please take a look at my tested .PBIX file then compare it with yours to find where is the issue.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,462 guests
Please welcome our newest community members: