Sunburst - Uneven Hierarchy Data Issue

[amitkumar82]

Hi,

I have 10 levels of hierarchy data which is uneven hierarchy. Not all rows will have value for all columns as shown below :

Col1	Col2	Col3	Col4	Col5
1	2	3	4	5
1	2	3	4
1	2	3
1	2

I need to create a sunburst where the Blanks values should not be dispayed as sections of chart. Can it be done?

Currently when I use this data then I get sections on sunburt with blanks.

Amit

[chrisnewman]

@v-lili6-msft I've tried this and can't get it to work. I don't quite understand this step "In the report, use Attribute and Value as the filter." Are you able to describe it again please.  Many thanks

@amitkumar82 Did you manage to get it to work?

[v-lili6-msft · Accepted solution]

hi, @amitkumar82

You may try this way as below:

Step1:

In Edit Query, select column Col1, Col2, Col3, Col4, Col5 ... then click Transform->Unpivot Columns

Step2:

If there are null values, filter them, then Close&Apply

In the report, use Attribute and Value as the filter.

Best Regards,

Lin

[amitkumar82]

Hi.

Thank you for your response.

Amit