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 the slicer the Chart should show AA in the X axis
If I select AA from the slicer then it should show AAA
If I select AAA then it should stop at that.
Default should start at A
Usually we have static columns and we can drill down from the chart itself. However ,this time we do not want to start from the begining level if someone is opening from Sub Category. How can dynamically achieve this ?
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.
2 Replies
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.