Forum Discussion
Create a slicer using multiple columns of a table - NOT NESTED
I want to create slicers that list categories representing multiple different columns in my dataset in a non-nested way. For example, I have in my central demographics table a bunch of columns re...
lucadelicio
Impactful Individual
Impactful IndividualHi,
try to go into the power query transform data mode:
- REFERENCE the table
- Unpivot all the columns
- Remove other columns
- Distinct value
Then put the filed into the slicer.
In this way you have the slicer connected to the column of your starting table.
Here the pbix link:
https://we.tl/t-mVLwIdW6ZI
I hope I have been helpful.
Let me know if resolve your problem.
It's more easier to help you if you upload your pbix.
Mark it as a solution if resolve your problem.
Ciao!