Forum Discussion

Dominik82's avatar
Dominik82
Frequent Visitor
3 years ago

Filter multiple columns with single dropdown slicer (without hierarchy)

Hi there,

 

is there a possibility to create a single slicer with a dropdown selection, which contains values from different columns?

Example table with the values

In my report I want to have a slicer with the values from the three columns "Warranty", "Data" and "Date".

 

 

Thanks for your help 🙂

Dominik

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Dominik82 Well, one, you could unpivot those columns in Power Query. Two, you could create a disconnected table for your slicer like below and use a measure that takes it into account.

    Slicer Table =
  VAR __One = DISTINCT(SELECTCOLUMNS('Table'[Warranty]))
  VAR __Two = DISTINCT(SELECTCOLUMNS('Table'[Data])
  VAR __Three = DISTINCT(SELECTCOLUMNS('Table'[Date]))
  VAR __Result = UNION( __One, __Two, __Three )
RETURN
  __Result
    • WorkmanK's avatar
      WorkmanK
      Frequent Visitor
      2 years ago

      SELECTCOLUMNS requires 2 arguments.  This does not work. =/

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi 

     

    you could duplicate the table in power query, unpivot the columns in the duplicate table:

     

    Join the 2 tables in model view, crossfilter both directions:

     

     

    Then add a slicer using the value field from the unpivoted table:

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


    • Dominik82's avatar
      Dominik82
      Frequent Visitor
      3 years ago

      Hi Greg_Deckler , Hi DOLEARY85 

      Thanks for your first help, but in my mind this will not help in my case.

      From your help I see, that there was a missing information from my side (sorry!).

      The columns in my example are calculated with a formular depending on other data in my table.

      So I can't duplicate this table as this formular will be lost (or I have to enter them twice).

       

      Maybe there's another possibility to filter the table on different columns with only one slicer visual?