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 All,
I am seeing a slicer to slicer reaction I want to change.
Simply for example we have two slicers A & B. If I change slicer A value slicer B changes which is ok. But if I change Slicer B it changes slicer A.
So if slicer A is a list of companies I select a company Slicer B shows a list of employees for that company. But if I first change slicer B first it may show a few companies the employee works for in Slicer A instead of the full list. Is there a way to stop that so the full list of companies in Slicer A stays visible?
Thanks,
-Tony
Solved! Go to Solution.
Hi, @Anonymous
I'd like to suggest you use 'Edit Interaction' in 'Format' ribbon. If you have edit permissions for a report, you can use Visual interactions to change how visualizations on a report page impact each other.
For further information, please refer to the following official document. Hope it helps.
Change how visuals interact in a Power BI report
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I'd like to suggest you use 'Edit Interaction' in 'Format' ribbon. If you have edit permissions for a report, you can use Visual interactions to change how visualizations on a report page impact each other.
For further information, please refer to the following official document. Hope it helps.
Change how visuals interact in a Power BI report
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks but is did not work. I changed a screw looking indicator from white to black for the visualization/slicer to the left of the slicer that I did not want to be affected. I am wondering how Power BI Desktop determine the dependencies? Doe it use a tab order? Does it look at coordinates of slicer to the left, right top and bottom?
Thanks!
Hi Tony,
Same procedere with slicer B.
Regards FrankAT
Hi,
Select the slicer B (right side slicer in below image) and go to the Format tab click on Edit Interactions and remove interaction on slicer one(left slicer highlighted red)
Did I answer your question? If Yes, Give me a Kudo
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |