cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shakti22 Visitor
Visitor

Slicer for multiple columns

I'm working with a senario in which I need to create single slicer for multiple columns, I have tried few DAX quaries with the help of similar questions asked on forum but I was unable to make that work.

 

Below is my data view on which I'm working

 

Brandtop 10 pertop 20 pertop 30 pertop 40 per
B10001
B21111
B30111
B40011
B50001

 

I am looking for solution in which I can select Top 10, Top 20 or Top 40 from filter to reflect only those brands in various charts which denotes 1 in correspond to the selection.

 

Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-xjiin-msft Super Contributor
Super Contributor

Re: Slicer for multiple columns

@Shakti22

 

In your scenario, to achieve your requirement. You can refer to following steps:

 

1. Unpivot your source table columns. To make them as fields in Slicer.

Go to Edit Queries -> Choose your source table and select column Brand -> Go to Transform option, find Unpivot Columns and choose Unpivot other columns:

 

1.PNG

 

2. Close & Apply. Then you can simply create Slicers:

 

2.PNG3.PNG

 

Thanks,
Xi Jin.

2 REPLIES 2
Super User
Super User

Re: Slicer for multiple columns

When you load the data, unpivot it before it is loaded. Click the brand column and then select “unpivot other columns”. You can then place a slicer on the new attribute column. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
v-xjiin-msft Super Contributor
Super Contributor

Re: Slicer for multiple columns

@Shakti22

 

In your scenario, to achieve your requirement. You can refer to following steps:

 

1. Unpivot your source table columns. To make them as fields in Slicer.

Go to Edit Queries -> Choose your source table and select column Brand -> Go to Transform option, find Unpivot Columns and choose Unpivot other columns:

 

1.PNG

 

2. Close & Apply. Then you can simply create Slicers:

 

2.PNG3.PNG

 

Thanks,
Xi Jin.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 293 members 3,473 guests
Please welcome our newest community members: