Hierarchy in Charts - Custom Column Values

Question

I have the below chart in my report. In X-Axis I have given Value Stream and Stage Time to maintain hierarchy. In the columns I have given Stage and Pending Quantity.

When I drill down, I could see the below appearance. After drill down I am not expecting the Pending Quanity and expecting only the Stage Quanity. How can this be done ??? Please help

amitchandak · Answer

Anonymous , You can chart type on Drill down. The first one stacked. The second one looks like a tornado 
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380768?tab=Overview
&nbsp;
You can that on Drill Through
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough