Forum Discussion

garg14194's avatar
garg14194
Regular Visitor
9 years ago

Drill Down

I have a problem with drill down. I have an overall value which is computed as multiplication of two elements. If click on the data bar of overall value, I want it to drill down to its multiplication components. Is it possible

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi garg14194,

     

    Drill down action on the chart visual requires hierarchy. In your scenario, please use sample data to clarify your requirement. 

     

    Best Regards,
    Qiuyun Yu 

    • garg14194's avatar
      garg14194
      Regular Visitor
      9 years ago

      Hi Qiuyun Yu, 

       

      Following is a specimen of example I am talking about.

       

       

      A         7 (Average of its elements A1 and A2)

       A1      9 (product of its elements A11 and A12)

        A11   3

        A12   2

      A2       5

        A21   1

        A22   5        

        

      First I want A then A1-A2 and the A11-A12-A21-A22 on drill down. Basically A ->A1/2 -> A11/12/21/22 values on drill down.

       

      Thanks