Parent & grandparent Hierarchy, dont need the nulls

[dobregon]

Hi,

I have a lists of assets with their parent and granparent group (depends of if they have or dont have) like the below picture.

So, as you can see there are some projects that have Parents and granparents and some projects dont have parent or grandparent or both. If we do a hiearchy in excel (but it will be the same in PBI)  we receive something like below picture; we can see that the projects with parents or grandparents NULLS will be en a group of (blank).

 But I need that when any column has null, the system ignores that column and show something like below picture.

Can someone help me on this?

Thanks in advance and regards!

[v-frfei-msft]

Hi @dobregon,

Based on my test, it is not possible to meet your requirement currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

Regards,

Frank