Two slicers based on the same column

[Anonymous]

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!

[tamdo95]

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.

[Anonymous]

Hi, 

my issue is to have no values in "Geo" slicer when I am choosing anything in week slicers. 
When I have different dates in slicers, "Geo" slicer is empty. When I am choosing the same date in both slicers, I have possible values in "Geo" slicer. 

[tamdo95]

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 

[Anonymous]

Is there any solution to fix it? To have any values in "Geo" slicer? If not, how can I build report to compare panels within selected date and still have possibility to filter by any other fields (i.e Geo) ?

[v-xulin-mstf · Accepted solution]

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!