Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Pie Chart

Hi everyone, 

 

I really need help with this. I created a pie chart to compare the the difference between attendees and registers as below:

However, it looks like Power BI takes the total of attendees and registers (100%) and compares each group with it. Do you know how I can make registers as 100% and compare attendees with registers only. Since I believe the number shouldn't be this low. I would preferably use pie chart for this case. But if you have other suggestions, I'd love to hear from you. 

Thanks a lot!

 

Tessa. 

Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi Anonymous, Can you subtract Registrations from Attendees to give you the difference and then add that measure and attendees to your visual?

4 Replies

  • davehus's avatar
    davehus
    Memorable Member
    4 years ago

    Hi Anonymous , Have you a column the indicates if someone enrolled and aslo attended the course?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi davehus, 

      Thank you for your response. Unfortunately I only have 2 columns like this:

      So the dataset gives the number of registers and attendees for each webinar we do. But no data of people is involved. 

      • davehus's avatar
        davehus
        Memorable Member
        4 years ago

        Hi Anonymous, Can you subtract Registrations from Attendees to give you the difference and then add that measure and attendees to your visual?