Forum Discussion
Dynamic Stacked Bar Chart (Possibly With Slicer?)
I am looking to visualize the following scenario in one stacked bar chart that changes to depict the category(s)/scenario that I choose:
4 friends are in a scavenger hunt. They must find items that fall into one of 4 categories: food, sports, art, nature. Within each category there are multiple items that can be found - players can find an item more than once (ex., jim found 2 footballs). I am looking for a way to put together a stacked bar chart that can show each friends score for each category (my current guess is that this would be through a slicer). So the axis would be the same no matter the scenario, because I want the score for each friend no matter the category. But within each category I would also like to see how many of each item was found by each friend. Is there a way to establish groups within pbi to allow for this sort of bucketizing (ex., hotdogs and Pizza belong to "Food")? The key is that this is dynamic - I want to show each friend's score (as well as item breakdown) for whichever/as many categories as I choose. I have drawn a sketch of what I imagine this to look like that is attached. Thanks in advance!!
2 Replies
- amitchandak
Super User
Anonymous , My idea would be having another visual which shows break down when you click on that(You can have another viusal
or drill through -https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough) .
Or may use report tooltip . https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
Another option is Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
- v-xulin-mstf
Community Support
Hi, Anonymous
Currently visual only supports clustered columns and stacked columns individually.
As your expected output, maybe it need to Combine a clustered column with a stacked column.
It is not supported in power bi now, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas
I use stacked column chart to create a visual as:
If you need, please try the demo: Dynamic Stacked Bar Chart (Possibly With Slicer?)
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly
