Forum Discussion
drill down based on legends
I am creating a stacked area chart with Moths on X-axis and sales on Y axis and product as legends. Now I want to create a drill down on the charts with Praducts->Category->SubCategory, is it possib...
No one gets it :).
I created for this a second custom table with an unpivot on those 4 columns and a relationship with the ID between them. Then 1 Chiclet slicer for the unpivotted table and 4 'classic slicers'.
But yes, I'm quite curious if there is an easier way for my end users to get a drill down on legend.
I get it. I'm having the exact same issue as a new user of PowerBI and to be honest I thought this would be easy seems like this is what PowerBI is meant to do.