I want to create a slicer for multiple columns.

[Anonymous]

State	April(18-19)	April(19-20)	April Var.(No.s)	April Var.(%)
NCR	20	90	70	x
KAR	25	70	45	y
MAH	76	69	-7	z
GUJ	89	56	-33	r

I am working on visualization for my division on such data in which I want to create a filter for month-wise (April-March).

I want to create a filter or a slicer in such a way that I can select a particular month or month and multiple columns I can visualize with respect to that.

Please help me with this issue.

Regards

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Do you mean you'd like to create a slicer eg: when you select April, then filter all April related columns?

I think you'd unpivot the columns first and then use the matrix visual, put the Attribute as column, and add the slicer, with search option enabled. 

Then you can get all April related columns when you search it in the slicer. 

[v-diye-msft]

Hi @Anonymous 

Not quite understand your requirement, you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak]

@Anonymous , refer if timeline slicer can help you

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=Overview

[Anonymous]

This is the sample table I have to use in Power Bi Desktop. Now, I want to create a slicer in such a way that , if I select April, it shows me all April Columns or any other month or multiple.

Please help me to resolve this issue.