Create a drill down on stacked chart

[shankulk]

Hi,

I have some sample data as shown:

Site	Ready	Not Ready	Training	Break	Other
A	78%	22%	0%	5%	16%
B	57%	43%	0%	6%	37%
C	56%	44%	0%	1%	43%
D	94%	6%	0%	0%	6%

Where 'Site': Call Center Site,

Ready: % of time agents are in a ready state

Not Ready: % of time agents are in a not ready state (further broken down by 'Training', 'Break' and 'Other' states)

I want to show a stacked graph that shows a proportion of time in Ready vs Not Ready State; and when drilled down on Not Ready, it should show proportions of Training, Break and Other states. The Excel equivalent of this would be a pie of a pie chart, but I am stuck when I try to do this in PowerBI. Any advice would be helpful. Thanks!

[shankulk]

Hi,

I have some sample data as shown:

Site	Ready	Not Ready	Training	Break	Other
A	78%	22%	0%	5%	16%
B	57%	43%	0%	6%	37%
C	56%	44%	0%	1%	43%
D	94%	6%	0%	0%	6%

Where 'Site': Call Center Site,

Ready: % of time agents are in a ready state

Not Ready: % of time agents are in a not ready state (further broken down by 'Training', 'Break' and 'Other' states)

I want to show a stacked graph that shows a proportion of time in Ready vs Not Ready State; and when drilled down on Not Ready, it should show proportions of Training, Break and Other states. The Excel equivalent of this would be a pie of a pie chart, but I am stuck when I try to do this in PowerBI. Any advice would be helpful. Thanks!

[v-cherch-msft · Accepted solution]

Hi @shankulk

First, You may try to use 'New hierarchy' for 'Not Ready' Column.

Then use 'Add to hierarchy' for 'Trainning','Break‘,'Other' columns to add the 3 columns to 'Not ready' hierarchy.

Last, drag the columns as below:

Regards,

Cherie