Forum Discussion
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 | |
| 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
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
3 Replies
v-lili6-msftCommunity Support
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
Hi.
Thank you for your response.
Amit
chrisnewmanAdvocate I
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?