Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
Solved! Go to Solution.
Hi, @Cosmo1012
If you don't want the slicers to affect each other, you can follow these steps to do so:
Just light up the slicer or chart you don't want to be affected by the icon marked below.
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.
Hi, @Cosmo1012
If you don't want the slicers to affect each other, you can follow these steps to do so:
Just light up the slicer or chart you don't want to be affected by the icon marked below.
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.
@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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |