Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm working on a report that is meat to work as a tool that enables to compare two groups of data (please see the picture below).
Both groups include the same slicers and the same visuals. HOWEVER, the slicers in group 1 need to apply to visuals in group 1 ONLY. Slicers in group 2 need to apply to visuals in group two only.
I have tried to use the Edit interaction function and picked a slicer from group 2 and clicked on "None" on all the slicers and visuals in group 1. However, this slicer from group 2 is still filtering the visuals in group 1.
Is it possible to make this work in Power BI?
Would be grateful for any input,
Alisea
Solved! Go to Solution.
Hi @Alisea_MI
Base on my test, it works well in my environment.
Create a slicer and a matrix:
Copy the two visuals:
Edit interactions as:
Here is the output:
Here is the official documents: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Please follow the steps and retry to check if the problem still exists.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Alisea_MI
Base on my test, it works well in my environment.
Create a slicer and a matrix:
Copy the two visuals:
Edit interactions as:
Here is the output:
Here is the official documents: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Please follow the steps and retry to check if the problem still exists.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, @v-xulin-mstf ! I think the problem was that I had too many elements and some of them cover these "None" buttons. I needed to put all the element apart in order to make sure that i have checked the "Non" boxes for all the necessary visuals.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |