Multiple legens in a stacked column chart

[Anonymous]

Hi Community, 

I~m working on a request for displaying multiple levels of visualization on a column stacked chart. So going from a general visualization to a more specific one. 

For example: 

Having in the standard or general level when starting the dashboard this view:

And by pressing on a hyerarchical view button been able to display a more specific visualization on the data. Like getting this:

 I am unable to put multiple legends into one visualization... 

I have done it with the axis field, but in this case doing it with the axis won't be useful for me. 

Please any help or advice related with this situation would be appreciated. 

Thanks

[v-yingjl]

Hi @Anonymous ,

If the dataset has a hierachy, you can try to use drill down / drill up in the visual. Please refer:

1. Drill mode in a visual in Power BI
2. Drill Up and Drill Down Reports in Power BI

Or if you want the hierachy shows directly, you can try to use a custom visual 'Hierachy tree' in appsource. Please refer:

1. Hierarchy Tree - xViz
2. Hierarchical Tree – Advanced Custom Visuals for Power BI

Best Regards,
Yingjie Li

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

[Greg_Deckler]

Well, if you can format data in a specific way, this will help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-intelligence-functions-including-Week-t...

Otherwise, you could use stacked visuals and bookmarks.