Waterfall - Drill down / hiearchy

[Anonymous]

Hello,

I have a waterfall chart showing Sales from Previous Year building to Current Year with Regions as Breakdown. 

I'd like to build it so that when a certain region is highlighted, or drilled down upon, the chart transforms to show PY/CY volume for that particular Region, with states in that region as the new breakdown. 


Is this possible?

Many thanks!

[v-piga-msft · Accepted solution]

Hi @Anonymous,

---

---

I have a waterfall chart showing Sales from Previous Year building to Current Year with Regions as Breakdown. 

I'd like to build it so that when a certain region is highlighted, or drilled down upon, the chart transforms to show PY/CY volume for that particular Region, with states in that region as the new breakdown. 

I'm a little confused about your scenario.

Do you want to create the hierarchy under breakdown? If it is, I'm afraid that we cannot create hierarchy under breakdown. We only could create hierarchy under Category.

If it is counvenient, could you share some screenshots to describe your scenario in more details?

Best Regards,

Cherry

[Anonymous]

Hi Cherry,

Thanks for getting back to me, unfortunately as your explanation indicates I don't think that what I'm hoping to do is possible.

-Ben