Forum Discussion
Trouble visualising data
Thank you Ashish,
I had taken my quest off-line and found the perfect solution, a Nested Pie Chart. However, it does not look like BI supports Nested Pie Charts.
This lead me to the Sunburst downloadable visual from Microsoft, but since that is just doenut and wastes the middle, I am going with Sunburst by MAQ Software, which runs with the same idea but offers nested piecharts, with the addition of Data Labels, so that people can see without the need to hover.
It is still work in progress, but it is doing what I need.
Hi Anonymous ,
According to your description, I created the test data.
I created a measure to count each category.
Take Type/Sub Type as the axis, Catagory as the legend, and measure as the value.
Measure = CALCULATE(COUNT('Table'[Type]),ALLEXCEPT('Table','Table'[Type],'Table'[Sub Type],'Table'[Catagory]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, Liang
I personally find it a bit difficult to get much from that format, so our board will be totally lost. Let me give you a greater range of data and I'll see if I can Come up with the kind of graphic I think I am looking for, but I am open to any ideas on clearly presenting the data.
This is the break-down of all the options of the Deployment team:
| Type | Sub-Type | Catagory |
| Deployment | Install | Computer |
| Deployment | Install | Mobile Phone |
| Deployment | Install | Monitor |
| Deployment | Install | other |
| Deployment | Install | Printer |
| Deployment | Install | Scanner |
| Deployment | Procurement | Purchase Approves |
| Deployment | Procurement | Purchase Query |
| Deployment | Procurement | Quote sent |
| Deployment | Support | Equipment moves |
| Deployment | Support | Obsolete collection |
| Deployment | Support | Other |
For me, in Power BI, I think I and looking to Drill Through
Which will drill through to a chart like
However, I am open to other ideas that may simplify this to a one-stage graph.
Thank you Ashish,
I had taken my quest off-line and found the perfect solution, a Nested Pie Chart. However, it does not look like BI supports Nested Pie Charts.
This lead me to the Sunburst downloadable visual from Microsoft, but since that is just doenut and wastes the middle, I am going with Sunburst by MAQ Software, which runs with the same idea but offers nested piecharts, with the addition of Data Labels, so that people can see without the need to hover.
It is still work in progress, but it is doing what I need.
