Forum Discussion
Solved
Using a slicer to select a column
Hi, Can someone help me with slicers? I have a table similar to the following; Name Department January February March April May June July August September October November December Abi ...
Hi Quadrelli ,
For your requirement, you could follow the steps below.
If you want to create a slicer with Month, you need to unpivot your month columns in Query Editor.
Then you could get the data model like this.
Then you could create the matrix and the slicer.
More details, you could refer to my attachment.
Best Regards
Cherry
v-piga-msft
Resident Rockstar
Resident RockstarHi Quadrelli ,
For your requirement, you could follow the steps below.
If you want to create a slicer with Month, you need to unpivot your month columns in Query Editor.
Then you could get the data model like this.
Then you could create the matrix and the slicer.
More details, you could refer to my attachment.
Best Regards
Cherry