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.