Handling the multiple level of Hierarchy for Drill Down

reemapinto — Mon, 03 Apr 2017 10:44:08 GMT

Hi,

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)].

Now,

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 ?

topic Handling the multiple level of Hierarchy for Drill Down in Developer