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
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?