Data model

[Anonymous]

I have the following data. 

Hi,All.

I have data in this format.

I need to build matrix visualization with the following hierarchy like:

Architecture ->
             ->Asses Inventory
                              ->Program
              ->Process
                              -> Asset Inventory

and so on.

Should I split the table and build a different data model to achieve this?

PS- Ignore the typo Asses inventory.

Any help is appreciated. Thanks

[amitchandak · Accepted solution]

@Anonymous , refer if this can help

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-child-functions-in-dax

Slicer is shown , but you can display matrix

[Anonymous]

Thanks Amit, it solved 95% of the problem. When I try to display it in a matrix, I have some blank rows. I do not want that.

How can I get rid of rows with blank data?

Here are the columns that I have created:

Thanks 🙂