Forum Discussion

OSS's avatar
OSS
Helper III
7 years ago

Drill down - Bar chart

Hi everyone

I need a help related to the drill down.

I have different measures which I need to show in a single bar chart.

Measure A, Measure B, Measure C etc.

After creating bar chart I would like to add detail table. Measure A is the sum of A1 and A2. Bar B is the sum of B1 and B2 etc. 

Is it possible to drill down and show chart for A1 and A2 clicking to the A bar? 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    OSS ,

     

    Only original columns can be drilled up/down, so you need to build a hierarchy on Column "A" and "B", in column "A", there should be subcolumns "A1" and "A2", in Column "B", there should be "B1" and "B2".

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • OSS's avatar
      OSS
      Helper III
      7 years ago

      Thanks for your response. Actually I do not have any hierarchy among the data. May be drill down is not possible in this case, but I wonder is there any way to link different measures with each other. And clicking to one chart, or image, or object reach another one.