How to deal with nulls in a hierarchy

[Sainodion]

@need urgent help.

Hello I am building a hierachy from level 1 to 5 and I have null values in Level 2,3,4 and 5.How do i take care of these blank values when i create my visuals?

Thank you

[sevenhills · Accepted solution]

Since you did not provide any sample data, and expected output. I am assuming you may want to read some info.

I am not sure whether you are familiar with Ragged hierarchy.

If not, go through these and takes time for the first timers to understand:

• https://learn.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-supplemental-lesson-rag... (This is not Power BI but helps you understand the concept)
• Dax concept of parent child hierarchies: https://www.daxpatterns.com/parent-child-hierarchies/
• Path, Pathitem, pathcontains, ...

Say, you have levels or level names, then you can look into the last part of the video: 
https://www.youtube.com/watch?v=xBlu6QmInY4

Hope this helps!

• https://www.youtube.com/watch?v=xBlu6QmInY4 - Say, 

[Sainodion · Accepted solution]

Thank you for your response and sharing these links they were very helpful

[sevenhills · Accepted solution]

Since you did not provide any sample data, and expected output. I am assuming you may want to read some info.

I am not sure whether you are familiar with Ragged hierarchy.

If not, go through these and takes time for the first timers to understand:

• https://learn.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-supplemental-lesson-rag... (This is not Power BI but helps you understand the concept)
• Dax concept of parent child hierarchies: https://www.daxpatterns.com/parent-child-hierarchies/
• Path, Pathitem, pathcontains, ...

Say, you have levels or level names, then you can look into the last part of the video: 
https://www.youtube.com/watch?v=xBlu6QmInY4

Hope this helps!

• https://www.youtube.com/watch?v=xBlu6QmInY4 - Say,