Here is a table indicating the parent-child relationship within same table
[Refering the link(http://www.daxpatterns.com/parent-child-hierarchies/) I created Hierarchial Levels(Level 1 to Level 7)].
I'm trying to present this data in a pie chart where "hierarchy"(i.e. Level1 to Level7) is legend & "count of 'Id'" as value.
Initially in the first level only 'Ids' 1 and 12 are shown. On drill down, by clicking 'Id' 1, I'm expecting the pie chart to show 'Id' 2 alone.
But, along with Id 2 , "Blank" is also shown.
Similarly when 12 is drilled down, Id 4 and Blank is shown. On further 4 is drilled down, 7, 8 & "Blank" is shown.
How to avoid Blank ?