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 ...
Need Help
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. =/