Dynamic Bar Chart axis

[Anonymous]

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]

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.

---

[v-yuta-msft · Accepted solution]

@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.