How to create option to view subcategories within a clustered bar chart?

[Anonymous]

Clustered bar graph represents level of knowledge of a survey population for 3 different organisations, have demographic data with the breakdown of what groups (e.g. scientific researchers) answered to the question, would like to be able to include an option to view the answers of each specific group on their own. 

Any help would be greatly appreciated. 

[v-luwang-msft · Accepted solution]

HI @Anonymous ,

You could custom tooltop to achieve what you want:

Detail operations refer:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop 

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

Best Regards,
Lucien

[Anonymous]

Hi Lucien,

Thank you very much. I was hoping to be able to do it by having a menu beside it and when an option is selected the graph would collapse to that specific group. Is this possible?

 

[v-luwang-msft]

Hi @Anonymous ，

In my opinion,you could try to use bottons with bookmark to achieve this.

When you edit a report in Power BI Desktop and the Power BI service, you can add report bookmarks to capture the current state of a report page. Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on. When others view your report, they can get back to that exact state by selecting your saved bookmark. 

refer:

https://www.c-sharpcorner.com/article/how-to-add-button-using-bookmarks-in-power-bi/

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop 

https://www.c-sharpcorner.com/article/how-to-add-button-using-bookmarks-in-power-bi/ 

Best Regards

Lucien