Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicer Options

Hi All,

    

          I need to change the slicer setting.

 

            The above image the slicer is set in Multi-Select and Show all is on.

            If select all option it shows all the data correctly.

 

            But in above Image i deselect all the filter this time also showing all the data.

 

 

 

          I need to set if i deselect all means that table visual is blank.

          How to do?

          Is this possible?

          Please help me.

           Thanks in advance.

Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    Anonymous 

    If I can interest you in using an alternative slicer visual, namely "Hierarchical Filter", then the behaviour seems to be what you were looking for.

     

     

    The problem with the Core Slicer visual is that "Select All" has the same effect as clearing all selections (confirmed by examining the DAX queries for the table visual).

     

    There could be other methods but this seems a convenient one 🙂

     

    Regards

9 Replies

  • OwenAuger's avatar
    OwenAuger
    Super User
    2 years ago

    Anonymous 

    The only method I can suggest is to write a measure that detects whether a filter has been applied on the slicer field, and apply this measure a visual-level filter on the table.

    PBIX example attached.

     

    In my PBIX, I created this measure:

    Name Filtered = 
INT (
    CALCULATE (
        ISFILTERED ( Data[Name] ),
        ALLSELECTED ()
    )
)

    Then added it as a visual filter to the table (set equal to 1):

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi OwenAuger ,

       Thanks for your reply.
      This is working good.

      But if i select all option now also that table is blank.

       

       

      I need if i click select all the table shows all the records.

      • OwenAuger's avatar
        OwenAuger
        Super User
        2 years ago

        You're welcome 🙂
        Sorry, I missed the "select all" requirement. That actually makes it trickier, as "Select all" is equivalent to clearing the slicer at the moment.

         

        I will take a look and get back to you.

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi Anonymous 
    No , That's no way possible.
    Select all = No data is selected
    Both the meaning is same in power bi

    "You cant show blank value in table when nothing is selected"

    If my post helps please give kudos and accept it as a solution!
    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    hi Idrissshatila 

              Thanks for your response.

              Any other way to done this logic.