Forum Discussion

RobbLewz's avatar
RobbLewz
Helper II
6 years ago
Solved

Hide Clear filter

Is there a way to hide the clear filter (rubber icon) on the page filters?

 

I have a few set to be "Require single selection" but they user still has the option to "clear" the filter which reverts it back to a select all...

 

I tried to display 0 value if more than one year was selected but it ignores the condition and still does the SUM()

 

Selected Year =
VAR cnt = CALCULATE( DISTINCTCOUNT(Dates[Selection]) )
RETURN
IF ( cnt > 1, 0.00, SUM('bi vwTotals'[GBP]) )
  • MFelix's avatar
    MFelix
    6 years ago

    Hi RobbLewz ,

     

    If you set the slicer to a distinct value people will only be abble to select one value from the slicer, also to make it a cleaner report what I ussualy do is to create a button with the filters and using bookmarkls I show and hide the slicers, or place it on a principle page so users must go back and select what they need something similar to this:

     

     

    As you can see the period slicer only allows one selection so the users will not be abble to select, in this case I have opted by making a bar on the left side but can be only an icon or something similar.

     

    Just giving options.

     

     

     

7 Replies

  • Hi RobbLewz ,

     

    Why don't you use slicers instead of the page filters?

     

    In the slicers you can turn off the slicer header that is where the rubber is placed and users won't have acces to it.

    • RobbLewz's avatar
      RobbLewz
      Helper II

      Thanks, the user can still click a checked box in a slicer and effectivley reset it back select all though.

       

      People at top want the filter on the side for a "cleaner" report too

      • MFelix's avatar
        MFelix
        Super User

        Hi RobbLewz ,

         

        If you set the slicer to a distinct value people will only be abble to select one value from the slicer, also to make it a cleaner report what I ussualy do is to create a button with the filters and using bookmarkls I show and hide the slicers, or place it on a principle page so users must go back and select what they need something similar to this:

         

         

        As you can see the period slicer only allows one selection so the users will not be abble to select, in this case I have opted by making a bar on the left side but can be only an icon or something similar.

         

        Just giving options.