Forum Discussion
Two slicers based on the same column
Hello all!
I'd like to ask how to create two slicers based on the same column. The purpose is to compare some charts based on selection in two date slicers.
I have two similar panels where I am comparing the same charts like in the photo. Interactions are correct, I mean selection of "week1" slicer doesn't affect on the right side panel charts, selection of "week2" slicer doesn't affect on the left side panel charts. But in this case, "Geo" slicer is not showing anything to choose.
How can I rebuild it to achieve all available values in "Geo" slicer?
Report is based on one dataset.
Thanks!
Hi Anonymous
Click on 'Edit interactions'.
Click on visual which display 'Geo', and disable interaction with other slicers.
Click on other slicer, and do the same as above.
For more information, you can refer:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
5 Replies
Hello,
You can select the week slicer(Week 1 for example), then go to Format -> Edit interactions, uncheck the the interaction with the right panel. See the image below for more details. I hope it'll help.Because "GEO" slicer have interactions with the two date slicers at the same time. So if you have two different dates, you have zero value in "GEO" slicer
