Forum Discussion

rk1904's avatar
rk1904
New Member
1 year ago

Using a slicer filter by a top n

Hello,

I have a parameter top where I choose a top n and this measure IF([Rank] <= 'Top'[Top Value], 1, 0) to filter the visuals.

When I put the field with all the codes that are filtered by the measure in a slicer, that is a top 3, top 5, etc., the visual it is working (I just see the 3 or 5 codes) but when I choose the slice option "select all" the dashboard displays the total sum associated with all codes and not just the 3 or 5 that I see in the slicer.

How can I set "select all" to only consider the codes that are visible?

 

In this example I have a top 3 but the card is ignoring the 3 codes and show the result for all codes 

If I select manually select the 3 codes I got the result that I want

Another question is if I choose the top 10 and then I change to top 5, the filter only updates if I do a manual clear selections. Is there any solution for it to clean automatically?

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Remove the "Select All" option.  It is not useful if you only have a couple options anyway.

     

    Another question is if I choose the top 10 and then I change to top 5, the filter only updates if I do a manual clear selections. Is there any solution for it to clean automatically?

    You can not programmatically impacta a slicer visual in Power BI unless you use Power BI Embedded. 

     

    This special behavior of the slicer visual is also the main reason why default slicer choices are inompatible with RLS.