Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can I a hierarchy on a shared dataset that combine multiple tables? Is that even possible?
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |