Forum Discussion
Solved
Sunburst - Uneven Hierarchy Data Issue
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 ...
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
v-lili6-msft
Community Support
Community Supporthi, 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
Hi.
Thank you for your response.
Amit