Forum Discussion
Understanding slicer filtering and visual relationships
Hi!
I'm new to Power BI and I am working on my first report.
I hope someone can help me understand the slicer filtering and visual relationsships...
Picture 1 represents the unfiltered report.
When I filter my report slicer with for instance "2100", all visuals are updated with the values corresponding with only "2100" as in Picture 2. This is good!
However, when I press the first staple under 4) "Topp 10 Leverantörer" (suppliers) as in Picture 3 my visuals under 2) "Verksamhet per månad" and 3) "Topp 10 Kunder" (customers) only updates in relation to original numbers under slicer filter "2100" (original value/staple is transparent).
Is there a way to recalculate visual 2) and 3) when pressing a staple under 4) without the relation to original numbers. I want visual 2), 3) and 4) to update with new values/staples without relation to the original values. In other words, I want a pressed down visual to behave like the slicer filter above with "2100".
3) and 4) are filtered with TopN.
Anonymous , We have "highlight" interactions for Bar(by default) when you click on a value in another visual, other than slicers. You can change the interaction
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4
2 Replies
- amitchandak
Super User
Anonymous , We have "highlight" interactions for Bar(by default) when you click on a value in another visual, other than slicers. You can change the interaction
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4
- AnonymousNot applicable
Many thanks amitchandak, now it works like a charm!