Forum Discussion
drill down based on legends
For Axis, I have it like this..
Months
ProductGroup
Product
Category
The deafult on the X-axis is Months, when I drill down, Months from the X-axis disappears, and it is replaced by ProductGroup->Product->Category. I want to retain the month on the x-axis while drilling down.
To achieve this you need to use the 3rd button from left to right in the Top left corner of the visual
The Expand all down one level in the hierarchy button
then the axis will display all
Good Luck! :smileyhappy:
"Expand all one level down in the hierachcy" is working file, but it has several item on the x-axis, Month-ProductName (eg: Jan-ProductName1, Jan-ProductName2... Feb-ProductName1, Feb-ProductName2.. and so on).
I need just Jan, Feb, March on x-axis and Porduct details "drilling down" and stacked area chart like below
Did you ever get a resolution on this, I would like to accomplish the same task.
Any update on this? is the issue with the calculated table the solution?
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 would love this also, would be very powerful.
