Forum Discussion
Format data split in several columns for a Doughnut chart
Hi,
Im not sure if my brain is still on vacation or whats wrong. :smileyfrustrated:
I am stuck on how to visualize my deviations in a doughnut chart.
I have a dataset that looks like this below
Where 1= Not Ok
| Part No | Deparment | Sales person | Missing Planning customs approval date | Missing Planning Estimation of Cost | Missing Planning Order date | Missing planning Delivery |
| 1818 | A | Mike | 1 | 1 | 0 | 0 |
| 1819 | A | Mike | 1 | 1 | 0 | 0 |
| 1867 | A | Mike | 0 | 1 | 0 | 1 |
| 1885 | A | Mike | 0 | 1 | 1 | 1 |
| 1146 | A | Alex | 0 | 1 | 1 | 0 |
| 1461 | A | Alex | 1 | 1 | 0 | 0 |
| 1827 | A | Alex | 0 | 1 | 0 | 1 |
| 1461 | A | Alex | 1 | 1 | 1 | 1 |
| 1600 | B | John | 0 | 1 | 0 | 1 |
| 1025 | B | John | 0 | 1 | 0 | 0 |
| 1626 | B | John | 1 | 1 | 0 | 0 |
| 1593 | B | Lisa | 1 | 0 | 0 | 1 |
| 1019 | B | Lisa | 0 | 0 | 0 | 1 |
The idea is to have a doughnut showing number of parts with devation (1) per " Missing Planning type" and a drilldown within each "missing planning type" in this order:
1. Deparment
2. Salesperson
3. Part No
More or less like this picture:
How should i set up my data in order achive this?
Gorup By in edit queries or is there an easy DAX-trick?
Kind regards Marcus
3 Replies
Hi Marcus_swe ,
According to your description, my understanding is that you want to create a drilldown with the order: Deparment -> Salesperson -> Part No.
In this scenario, we can create a Hierarchy for them by draging these items to Deparment like below:
Then we can use the Deparment Hierarchy as Legend in Donut chart. But I would suggest you using the Clustered Bar chart, it will can display the detail when we drilldown.
Best Regards,
Teige
Hi TeigeGao
Thank you for the reply and the gifs. Very educational.
You are assuming correct regarding the drilldown order.
I get the drilldown and hierarchy to work as you show. But I can only get it to work with one chart per deviation type.
Where i get stuck is IF it is possible use one chart with the setup on the picture below.
Kind Regards Marcus
hi my wotk for above query.
Marcus_swe wrote:Hi TeigeGao
Thank you for the reply and the gifs. Very educational.
You are assuming correct regarding the drilldown order.
I get the drilldown and hierarchy to work as you show. But I can only get it to work with one chart per deviation type.
Where i get stuck is IF it is possible use one chart with the setup on the picture below.
Kind Regards Marcus
Marcus_swe wrote:Hi TeigeGao
Thank you for the reply and the gifs. Very educational.
You are assuming correct regarding the drilldown order.
I get the drilldown and hierarchy to work as you show. But I can only get it to work with one chart per deviation type.
Where i get stuck is IF it is possible use one chart with the setup on the picture below.
Kind Regards Marcus
