Forum Discussion
Small multiples chart filtered for each group
I might not be using the correct terminology for this but, I have a large data set (call it a list of products and each product has a team and each product has a few columns that are represented as days).. I plotted this out on a stacked bar chart.. great.. I see that you can make smaller sub charts "small multiples" automatically.. great.. done.. now I have 20 stacked bar charts broken out with the teams.. But the issue is that not every team worked on every product.. is there a way to still easily break this out but only show the products for that team with have non-zero days associated with it???
You can add a visual-level filter on the stacked bar chart. Add a filter to a report in Power BI - Power BI | Microsoft Learn
Select the stacked bar chart visual, set a filter to show items when the value is greater than 0 or is not blank on its Days (or Sum of Days) field in Filter Pane. Then apply the filter.
For example,
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
v-jingzhangCommunity Support
You can add a visual-level filter on the stacked bar chart. Add a filter to a report in Power BI - Power BI | Microsoft Learn
Select the stacked bar chart visual, set a filter to show items when the value is greater than 0 or is not blank on its Days (or Sum of Days) field in Filter Pane. Then apply the filter.
For example,
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.