Forum Discussion

powerbitv's avatar
powerbitv
Frequent Visitor
8 years ago

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...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

IF you add these fields underneath "Months" in that field, then you can drill down to them.

 

Something like

 

powerbitv's avatar
powerbitv
Frequent Visitor
8 years ago

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.

  • Sean's avatar
    Sean
    Community Champion
    8 years ago

    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:

    • powerbitv's avatar
      powerbitv
      Frequent Visitor
      8 years ago

      "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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Did you ever get a resolution on this, I would like to accomplish the same task.