Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Trouble visualising data

So I am trying to visualise the breakdown of Helpdesk tickets, and I'm not having any luck. Example: data is three text columns (Type/Sub Type/Catagory). So Type is the team (helpdesk, networks, dep...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

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.