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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Cosmo1012
New Member

Can you filter data with slicers two different ways and have it display on one map?

I am using two different slicers to slice the data in two different ways and want them both show on one map.

 

This is my example. 

 

I have a subject county I am looking at with an estimated population. This is shown on left side side with a red bubble on the map. I want to be able to slice this data and easily chose any county I want in the United states so that it is not locked in on one county. I have it set up so each slicer will not effect the right side slicers or map through editing interactions. 

 

I have comparable counties with similar population sizes on the right side. I have sliced the data to show a similar range of populations and a specific state (Georgia). I also want to be able to slice this data and pick any state that I want.

 

I want to display this on one map and not with two maps. I would like the Subject to be highlated in red and for me to be able to move it to any county I want. I also want to be able to highlight the comparbles in blue and move them anywhere i want. 

 

When turning on the filter for both my result is a blank map because the slicers are fighting one another. Below is a screenshot of my scenario.

 

 

 

Comparables map.PNG

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Hi, @Cosmo1012 

If you don't want the slicers to affect each other, you can follow these steps to do so:

vjianpengmsft_0-1713493780792.png

Just light up the slicer or chart you don't want to be affected by the icon marked below.

vjianpengmsft_1-1713493824918.png

If you need to highlight, then you can need to format your map conditionally according to your actual situation, you can refer to the following case solution:

Solved: Conditional Formatting Colors in Filled Map (V 2.1... - Microsoft Fabric Community

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

2 REPLIES 2
v-jianpeng-msft
Community Support
Community Support

Hi, @Cosmo1012 

If you don't want the slicers to affect each other, you can follow these steps to do so:

vjianpengmsft_0-1713493780792.png

Just light up the slicer or chart you don't want to be affected by the icon marked below.

vjianpengmsft_1-1713493824918.png

If you need to highlight, then you can need to format your map conditionally according to your actual situation, you can refer to the following case solution:

Solved: Conditional Formatting Colors in Filled Map (V 2.1... - Microsoft Fabric Community

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

amitchandak
Super User
Super User

@Cosmo1012 , I think interactions  can help

PowerBI Abstract Thesis: How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

 

 

or you have to use disconnected tables

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors