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

Hi powerbitv

 

It should be.  Just add those fields to the Axis area of the visualisation panel as shown:

 

powerbitv's avatar
powerbitv
Frequent Visitor
8 years ago

As mentioned I have Months on the x-axis..

  • 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: