Drill through Stack Bar chart for New calculated Column

[ARamalingam]

Hi All, I have created a stack bar chart and want to make drill through to the detail page. It seems the drill through only works for the whole bar. OR we can be able to cteate Hierarchy for the Data fields.  In our case, teh stack bar is created with Data fields and as wella s a calculated field. 

For Exampls , We have a stack bar chart with Dashboard Name and Users (External Users and Internale users count)

When i drillthrough the Dashbaord Name- External users it should open the page filtered with both the Dashbaord Name and External users. Same way in case if i need drillthough by clicking Dashboard name and Internal users it shuld be filtered for Selected dashboard name and Internal users. ANy help would be appreciated. Thank you.

[ARamalingam]

Thank you for your response. Appreciate it. 

But it sems it will work only for funnel chart. I have not seen  it iw working for the Bar chart. ANny suggestions on this. 

[arpit2196]

Hello @ARamalingam ,

I got the solution to your problem.

You need to add 2 different Drill Through detail pages for internal and external users separately to drill down from a stacked bar chart with a data field and calculated column field.

Step-1 

Step-2 Drill through for a detailed page of external users

Step-3 Drill through for a detailed page of internal users

Regards,

arpit2196

If this post helps, then please consider Accepting it as the solution and give kudos too 👍

[ARamalingam]

Thank you . Is tehre a way to drill to the same page by passing parameters?
Also the External Users and Internal users count are dispayed in the bar chart. And the calculation is as follows: 

Internal_Counts = CALCULATE(DISTINCTCOUNT('Query1'[Client]),left('Query1'[Status],8)="Internal")+CALCULATE(DISTINCTCOUNT('Query1'[Client]),left('Query1'[Status],8)="External")

External_Counts = CALCULATE(DISTINCTCOUNT('Query1'[Client]),left('Query1'[Status],8)="External")

[arpit2196]

Hi ARamalingam, Please refer to the below link for the required solution.

Drill through for calculated measure