Forum Discussion
Solved
How to have a multiple column slicer
I am wondering if it is possible to create a single slicer, which accounts for multiple columns and their values. Attached below is a sample of my data. For example, I want to be able to have a visua...
Hi andyring,
You should model your data in Query Editor to achieve this.
UnPivot the date columns into one "Date" column and then you can use this "Date" column in your slicer.
Prateek Raina
Hi andyring,
You should model your data in Query Editor to achieve this.
UnPivot the date columns into one "Date" column and then you can use this "Date" column in your slicer.
Prateek Raina
Wow, such a simple solution. Can't believe I didn't think about this. It seems to be working as I intended - thank you very much Prateek!
