Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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!
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.
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.
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
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) ?
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!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |