Forum Discussion
Creating Hierarchy in Matrix table using two different table
Hello Everyone,
Have a question regarding how we can create the hierarchy from two different dimension tables. Not sure if that is even possible?
I have a Location dim table, an Employee dim table joined with one fact table. There is a column name Client in the location table and driver in the Employee table can I create a hierarchy between those two tables. Relationship between two table
Thank you for your help.
Nepal101 you cannot create a hierarchy but in the visuals, you can drop the column from both the tables, let's if you are using a line chart, on the x-axis, you can have employee and location on Aix and that will allow you to drill up and down.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
Nepal101 you cannot create a hierarchy but in the visuals, you can drop the column from both the tables, let's if you are using a line chart, on the x-axis, you can have employee and location on Aix and that will allow you to drill up and down.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
What could be an alternate solution for it? If I am using Matrix.
Nepal101 In matrix, you can drop columns from both the tables on the row and it will work as hierarchy.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
