Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rdurrell
Regular Visitor

Adding a slicer by columns

Hello, I am new to Power BI and am having an issue trying to create a slicer to filter through my columns. For example, I have data broken down into a few groups as shown below:

rdurrell_0-1719332946308.png

 

I want to be able to add a slicer to filter through my visuals by column, but there is no option for this. I have tried making a new query and unpivoting the columns such as below:

rdurrell_1-1719333034502.png

This, however, is not feasible, since I want to be able to create a stacked barchart visual such as this: 

rdurrell_2-1719333197812.png

But when I create my new unpivot column, I cannot use the new 'values' column since I still want my data categorized into the groups. I also lose all my relationships when creating the new unpivoted column. How can I fix this??

1 ACCEPTED SOLUTION
NaveenGandhi
Super User
Super User

Hi


Can you try as below.
Screenshot 2024-06-25 171515.png

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

 
 
 
 
 
 
 
 
 
 
 
 

 

View solution in original post

3 REPLIES 3
NaveenGandhi
Super User
Super User

Hi


Can you try as below.
Screenshot 2024-06-25 171515.png

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

 
 
 
 
 
 
 
 
 
 
 
 

 

This worked great! My only remaining question would be how can I ensure that this slicer works with other related data?

Please take a look at data modeling in Power BI, Below playlist will get you through all the basics.

https://www.youtube.com/watch?v=9tF1IrfLflg&list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.