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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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