Forum Discussion
Drill through Stack Bar chart for New calculated Column
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...
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 👍
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")