The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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,
Solved! Go to Solution.
Irritatingly this cant be solved in powerBI
Irritatingly this cant be solved in powerBI
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
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.
@v-xiaotang, the problem is I want to have the generations automatically added to the matrix as the number grow.
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.
@samdthompson If these are columns, I doubt you can made it dynamic
@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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |