Forum Discussion
Waterfall - Drill down / hiearchy
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!
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
2 Replies
v-piga-msftResident Rockstar
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