Display all the hierarchy on a stacked bar chart

[mflore]

Hello, 

I would like to display at the same time all the levels on a stacked bar chart. I don't want to have to use the "show next/previous level" buttons.  

In practice, my problem is: 

I have a graph with number of people per skill level on various competency topic. (axis: competency topic; value: number of name; l egend: skill level)

I would like to show, on the same graph the evolution between 2 years 

So I thought that adding "year" on the axis and have for each competency topic the 2 years one under each other will be great. 

If you have any kind of solution, please share! 

Thanks a lot for your help! 

[v-yulgu-msft · Accepted solution]

Hi @mflore,

Based on my understanding, you want to display all the levels on a stacked bar chart in order to show the evolution between 2 years, right?

Currently, the only solution to display all the hierarchy on a chart is to use drill down, that is use the "show next/previous level" buttons as you mentioned. You can prefer to select the 'Expand all down one level in the hierarchy' as is highlighted in red in below image, in that case, it will show all levels and you can compare the difference between two years.

Best regards,
Yuliana Gu

[mflore]

That's perfect, thantks a lot! I had such an old version of PowerBi that i couldn't see this button at first !

Have a good day,

Regards,

Marie-flore