Create hierarchies from a column of a database

[Anonymous]

In my database, I have a column that has an account hierarchy as below:

1

11

111

112

1111

1112

2

21

211

2111

And so on...

I would like to establish a hierarchy scheme in PowerBI, where I can add all the values from the selected account down.
I do not know yet if I can do this in PowerBI or I'll have to do some mechanism in the database.

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

As the @richbenmintz said, structure of your resource table need to be changed. There are some arctile about parent and child, please review.

Parent-Child Hierarchies
Understanding Functions for Parent-Child Hierarchies in DAX

Best Regards,
Angelia

[richbenmintz]

In order to Achieve what you are after you would have to turn your single column into at least two column parent and child. Once that is done you can use the parent child functions in dax to flatten your P/C table into a standard dimension. If you are going to do the work to create the P/C table in the DB you are probably best to do all of the work in the database as you will get better sizing and compression; calculated Columns in Power BI are not compressed.