Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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 🙂



Resident Rockstar
Resident Rockstar



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 👍

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?

Super User
Super User

@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 __Three = DISTINCT(SELECTCOLUMNS('Table'[Date]))
  VAR __Result = UNION( __One, __Two, __Three )

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors