RENDERING HIERARCHICAL TASKS - BLANK ROW VALUES

[Syndicate_Admin]

Hello everyone!

I'm trying to represent in a matrix a budget breakdown structure, composed of prices that are at different levels of depth and there is a parent-child relationship between them.

The table where the hierarchical relationship of the chapters is found has the following form:

In addition, I have another table of facts with the elements that make up the budget. Each price has its WBS Code value.

To see that everything works well, I have tried to represent the table that appears in the image above and order it by levels to see how everything looks when unfolding it, but I have found that I always have blank rows, I leave some screenshots:

[Syndicate_Admin]

Hello! Thank you very much for the reply. In principle the information is found in the form you are suggesting, (each child task has a code that relates it to its parent task), through levels. The main problem I have is the white space, which I don't know how to remove. Do you know the reason why it appears?

Thank you very much in advance

[Anonymous]

Hi lpz314,

Please check if this pattern is helpful:
Parent-child hierarchies – DAX Patterns
If the question is for a solution, you may consider making a simple example file, which can be helpful in solving the question.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group