Forum Discussion
Drill Down
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
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-msft9 years ago
Community Support
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 DesktopBest Regards,
Qiuyun Yu