Forum Discussion

ARamalingam's avatar
ARamalingam
New Member
3 years ago

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...
Need Help
ARamalingam's avatar
ARamalingam
New Member
3 years ago

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's avatar
arpit2196
Frequent Visitor
3 years ago

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's avatar
    ARamalingam
    New Member
    3 years ago

    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")