Using a slicer to select a column

[Quadrelli]

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     Accounts      20         40            80       30    60    70    20    60         40              90          10              20

Bob    IT                  30         50            30       20    30    40    60    40         10              20          30              10

Cathy IT                  10         40            30       20    90    30    20    60         70              40          60              80

Doug Marketing     20        20             70       80    40    50    60    10        90              40           50             20

Ewan Accounts       30        40             30       90    70    60    40    20        10              80           70             30

I would like to use slicers to select the department but also use a slicer to select a month, I'm not sure how to do this, any ideas?

Thanks

S

[v-piga-msft · Accepted solution]

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