Is it possible to have multiple 100% stacked bar charts under each other

[EaglesTony]

Hi,

  I have a table that has Initiative and Art. (Parent and Child relationship)

  I have a 100% Stacked bar chart where the Y-Axis is the Initiative Key and X-Axis Pct Complete, which works fine.

  Now I want to have another 100% Stacked Bar Chart for Art so it will show the breakdown for the parent(Initiative), is this possible ?

[Anonymous]

HI @EaglesTony,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

Regards,

Xiaoxin Sheng

[MattiaFratello]

Can u provide an example? You want two separated stacked bar charts one for Initiative and one for Art? Maybe you want to drill down? https://learn.microsoft.com/en-us/power-bi/consumer/end-user-drill

[EaglesTony]

It would look similiar to this:

If I have to, I can use a drill through.

[EaglesTony]

I found something strange using the drill through, on the above, if i right click on the top bar 92%, it takes me to the detail just for "In Progress" items.

What I need from the drill through is to show based on the Initiative(which is next to the top bar and crossed out), thus I need to show that Initiative broken down by ART and then by Status.

[Anonymous]

HI @EaglesTony,

Perhaps you can try to create a measure formula to summary and get the current group total value, then manually calculate out percentage(modify its display format to percent) and use on the visual. After these steps, it will show the calculated percentage of each category.

Regards,

Xiaoxin Sheng