Forum Discussion
Dynamic change Axis AND Legend with Slicers
Hi guys, I am new to the community and excited to learn a lot! WIll be attending MS Data summit so let me know if you want to meet up. I am trying to provide users of my reports with a powerful an...
You could create a hierarchy of Area, Position, and Year. The first level would show Area totals, if you drill down without selecting a specific area, it will then show you position, and then by year.
Its not perfect but it does "change" the axis, and also gives you the ability to drill into an area and see position data for just that Area.
Hi mdannemiller, Your solution some how helped me to dril down my chart while keeping only single chart and having multiple attribute at the same time. Now i want to show only top 5 value in each drill down state for each hirarchy i set. Is this possible in hirarchy drill down method? I am using donut chart. Please see my example screenshot attached here: