Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

RENDERING HIERARCHICAL TASKS - BLANK ROW VALUES

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:

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    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