Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Power BI Map - Union of filters

I'd like to see all schools in a state by school district.  I have a spreadsheet of schools where School Type is used to identify whether the school is Public or Private.  Each schools lat/long is also in this spreadsheet.

 

When I upload the spreadsheet into Power BI, and add the lat/long into the appropriate fields, I see all schools.  But, if I filter by School District and also filter where School Type is private I get only those schools that are Private in the selected School District.

 

Instead I want all schools in a School District plus all those where the School Type is Private.

 

If you think in terms of a Venn Diagram, I want the area in both circles, not just the intersection of the circles.

 

How can I accomplish this?

1 REPLY 1
lbendlin
Super User
Super User

Filters are always applied on top of each other ("AND") .  You can only implement your "OR"  scenario by using measures and flags.

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)