Forum Discussion
Dynamic Bar Chart axis
Anonymous ,
You can use dax function LOOKUPVALUE() and PATHIETM() to achieve the parent level hierarchy value. For more details, please refer to blogs below:
https://powerpivotpro.com/2018/09/using-dax-to-handle-multiple-parent-hierarchies/
https://www.daxpatterns.com/parent-child-hierarchies/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
You can use dax function LOOKUPVALUE() and PATHIETM() to achieve the parent level hierarchy value. For more details, please refer to blogs below:
https://powerpivotpro.com/2018/09/using-dax-to-handle-multiple-parent-hierarchies/
https://www.daxpatterns.com/parent-child-hierarchies/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.