Drill Down

[garg14194]

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

[v-qiuyu-msft]

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]

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

[v-qiuyu-msft]

Hi @garg14194,

How's the source table looks like? How to calculate the A1 is 9 and A2 is 5? 

Assume data like below: 

You can use the matrix to drill down: 

Reference:
Use the new Matrix visual in Power BI Desktop

Best Regards,
Qiuyun Yu