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
- NaveenGandhiMemorable 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?
- NaveenGandhiMemorable 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