Forum Discussion
Dynamic Bar Chart axis
Hi, I have a requirement where the bar chart needs to change X axis based on value selected from Slicer. This is a Hierarchy SLicer. Example : A AA AAA If I select Category A from t...
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.
Hi Sdhamani,
i also need to achive same sinario in one of my reports.
if you have got solution for this post please share with me.