Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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.

 

2 Replies