Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filtering specific legends on stacked column chart

So, I have a bunch of data and had a rolling 12 months, each month had a stacked column chart broken down to category 1, 2, 3 and 4. 

There are 15 services which when an incident occurs are assigned a category based on severity. 

So, cat 1 and 2 might be all 15 services whilst cat 3 might exclude service 13 and 15 and cat 4 might be just service 15.

Also, some cats might exclude certain locations whilst others include all locations. 

 

Is it possible to filter the stacked column, so each section of a stack only reflects specific services?

I'm a complete amateur at PowerBI currently all I really understand is dragging and dropping fields to make graphs and tables. 

 

Thanks

 

Need Help

1 Reply

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You may put the field which has been dragged onto Legend box of Stacked column chart into slicer visual, then you can filter some special legends in slicer.

     

    If I misunderstood it, could you please share your sample data or desired output screenshots for further analysis, you can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.