Forum Discussion
Create a drill down on stacked chart
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!
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
2 Replies
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-msftMicrosoft Employee
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
