Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Measure when hovered over Stacked Bar Graph

Hi,   I have created a horizontally stacked bar graph, the stack is the percentage of the duration attended by the guest of the event. I want to calculate the percentage of guests who were in the s...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous try this measure

     

    PCT = DIVIDE ( COUNT('Sheet1'[Guest ID] ), CALCULATE ( COUNT ( Sheet1[Guest ID] ), ALLSELECTED ( Sheet1[Pct Activity Category] ) ))

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous Can you share sample data with some screenshot, and what you are trying to achieve.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k Sure, I couldn't attach a screenshot, so I have uploaded it on the drive and shared the link on the Main Post.

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous try this measure

     

    PCT = DIVIDE ( COUNT('Sheet1'[Guest ID] ), CALCULATE ( COUNT ( Sheet1[Guest ID] ), ALLSELECTED ( Sheet1[Pct Activity Category] ) ))

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      parry2k I tried the measure and on hovering over the graph I see the value 1.00. I have also provided more information with example in the main post, I hope it helps.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous make sure change the format of PCT measure to %