Forum Discussion

TalkingBits's avatar
TalkingBits
Frequent Visitor
6 months ago

Dynamically remove options on slicer, regardless on checked state

Hi, 

 

Im using a dax-measure to dynamically (depening on some other logic) remove slicer options, using the "filters on this visual". That works great as long as the options are checked. Does anyone know how to remove the options even if they are unchecked? 

 

The issue can be simplified to the following:

Suppose you have a slicer with the value "yes" and "no". If both values are checked in the slicer, and you add a "filters on this visual" "Basic filtering" = "yes", then "no" is removed. If "no" is unchecked previously, the "no" is not removed. Is there any way to always remove the "no" option, regardless of whether it is checked or not? 

 

Need Help

6 Replies

    • TalkingBits's avatar
      TalkingBits
      Frequent Visitor
      6 months ago

      Hi v-menakakota thank you for the link. 

      The problem is not how to create the logic that removes the slicer options. 

      The problem is that if there is a mix of unselected and selcted options, as in the example picture, then they are not removed. Maybe this is intentional as to show the user what they selected, but I would like to be able to remove all of them. 

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        6 months ago

        Hi TalkingBits ,

        Thanks for explaining. This behaviour is actually by design in Power BI. If a user has already selected or interacted with a slicer value, the slicer keeps showing it so users don’t lose track of their selections. Because of that, visual-level filters or measures won’t fully remove those items from the slicer list.

        Right now there isn’t a direct way to always hide those values. If you need full control, you could try using a disconnected table or a custom slicer setup so only the allowed values appear.

        You can also consider posting this as an idea in the Fabric Ideas forum for future improvement.Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

        Best Regards, 
        Community Support Team