Forum Discussion

MT2's avatar
MT2
Regular Visitor
7 years ago
Solved

Pie Chart - Columns from two tables

Hi guys,

 

I am fairly new to PowerBI. I need some help on creating a pie chart. I have got two tables. 

The first table contains the list of all employees in the organization and their office locations. And the second table contains the list of employees active of Training Portal.  I want to display a pie chart that shows the number of employees active on the training portal vs the total number of employees. 

 

Thanks in advance.

MT2

Need Help
Show and Tell
Tips and Tricks
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi MT2 ,

    The following is my sample you can have a try.

    Active = COUNTROWS(Table2)
All Employees1 = COUNTROWS(Table1)

    Best Regards,

    Xue Ding

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi MT2 ,

    The following is my sample you can have a try.

    Active = COUNTROWS(Table2)
All Employees1 = COUNTROWS(Table1)

    Best Regards,

    Xue Ding

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.