Creating a Hierarchy from Multiple Tables using a shared dataset

[Jsonify]

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

[v-luwang-msft · Accepted solution]

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]

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.