Dynamic Heirarchy

[samdthompson]

Hello, was wondering if anyone had made a dynamic heirarchy. 

I have a data set of livestock breeding. Each animal will have x number of progeny and so on over generations. I currently have 12 generations and this will continue to grow. The grandparent/parent/child relationship has been flattened successfully and I have a heirarchy that works as expected:

My problem is when I get another generation, I want it to automatically add itself to the hierarchy rather than having to manually add it in.

Currently:

GenA/

   GenB/

      GenC/

         GenD/

            GenE/

               GenF/

                  GenG/

                     GenH/

                        GenI/

                           GenJ/

                              GenK/

                                 GenL

When I get new data I need the heirarchy to automatically become:

GenA/

   GenB/

      GenC/

         GenD/

            GenE/

               GenF/

                  GenG/

                     GenH/

                        GenI/

                           GenJ/

                              GenK/

                                 GenL/

                                    GenM

Cheers,

[samdthompson · Accepted solution]

Irritatingly this cant be solved in powerBI

[v-xiaotang]

Hi @samdthompson 

Have you solved this problem? If yes, would you mind to accept the answer helpful as the solution or kindly share your solution to improve Power BI.
Really appreciate!

Best Regards,
Community Support Team _Tang

[v-xiaotang]

Hi @samdthompson 

How about using matrix?

Supposing you have a table bellow, then put it into matrix,

after you add a row into the table, the heirarchy will change,

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[samdthompson]

@v-xiaotang, the problem is I want to have the generations automatically added to the matrix as the number grow.

[v-xiaotang]

Hi @samdthompson 

thanks for your reply.

In fact, it cannot be automatically added to the matrix unless the data is added to the table of the data source. Powerbi desktop can be used to clean data, calculate data, but cannot create data to datasource.

In my previous example, if the hierarchy in your data source changes, the hierarchy in the matrix will also change accordingly. So I think modifying the data source is a better way.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@samdthompson If these are columns, I doubt you can made it dynamic

[samdthompson]

@amitchandak  And if I make then rows? Do I need to make some mad bridging table so people can look at everything from GenA downwards or from say GenG downwards?