cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jsonify
Frequent Visitor

Creating a Hierarchy from Multiple Tables using a shared dataset

How can I a hierarchy on a shared dataset that combine multiple tables? Is that even possible?

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Jsonify ,

in power bi desktop there is inline-hierarchy option but that only allows hierarchy from the current table. However if you have tables joined then you should be able to create drill down without any extra steps. All you need to do is select chart that supports drill down (column, bar etc) and put multiple fields from multiple tables (all joined) under Axis area.

 

 

Similar question refer:

https://community.powerbi.com/t5/Desktop/Creating-a-Hierarchy-from-Multiple-Tables/td-p/44602 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @Jsonify ,

in power bi desktop there is inline-hierarchy option but that only allows hierarchy from the current table. However if you have tables joined then you should be able to create drill down without any extra steps. All you need to do is select chart that supports drill down (column, bar etc) and put multiple fields from multiple tables (all joined) under Axis area.

 

 

Similar question refer:

https://community.powerbi.com/t5/Desktop/Creating-a-Hierarchy-from-Multiple-Tables/td-p/44602 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

lbendlin
Super User
Super User

yes - if that dataset is used with a local data model, and if the relationships are well defined.  Then you can pull in all the required fields via RELATED() and create your hierarchy in your target table.

 

Or - you could access the shared dataset in Analysis Services mode and run a custom DAX query that pulls these fields together.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!