Forum Discussion
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:
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:
This, however, is not feasible, since I want to be able to create a stacked barchart visual such as this:
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??
Hi
Can you try as below.If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
3 Replies
- NaveenGandhi
Memorable Member
Hi
Can you try as below.If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
- rdurrellFrequent Visitor
This worked great! My only remaining question would be how can I ensure that this slicer works with other related data?
- NaveenGandhi
Memorable Member
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