Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Tooltip Reports - Is there a way to apply two filters to the same card? State vs Region data on Map

Hi All,


I have a Tooltip Report for a US map. I want to show data for the state, as well as the overall region data. Right now, only one filter is being applied.



Power BI - State and Region Count.jpg


Is there a way to distinguish the state and region data?


Thanks for any information!

Super User III
Super User III

@sprague90 you can surely achieve this by creating new measure for Region which ignores the State filter. If you can share sample data, I can get you a measure to achieve this.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hey @parry2k,


I was working on this more today. This measure does *almost* I want to achieve






I issue I run into with it is that while it does calculate the regional data, it only shows the total for the "customers" in the state I'm hovering over.


For example, say I have a list of 10 customers with regional data. If say a state's top customers are Customer 2, Customer 6, Customer 10, then the regional data will only show those customers. The data is correct; I just want the top in that region, no matter the customer in the state.


I appreciate your help on this!

Hi, @parry2k . Thanks for replying!


This is a rough idea of the data.


I want the count of unique IDs by category. So, if I hover over Pennsylvania, I will see:



Category 1 (2)

Category 2 (2)



Category 1 (3)

Category 2 (3)


PennsylvaniaNortheastCategory 11236
PennsylvaniaNortheastCategory 11547
PennsylvaniaNortheastCategory 28456
PennsylvaniaNortheastCategory 29874
New YorkNortheastCategory 17412
New YorkNortheastCategory 28521

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors