Forum Discussion

bbreitenbach's avatar
bbreitenbach
Frequent Visitor
10 years ago
Solved

HR Churn visual in HR Sample

I am new to Power BI and would like to create the HR Churn visual that is part of the mobile HR Sample.   My table has the employee ID, hire date, and termination date if terminated. What columns/m...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    bbreitenbach

     

    Try to use a calculated table following below steps.

    1. The dataset is as below
    2. Create a calculated table
      newTable = UNION(ADDCOLUMNS(ALL(Emp[ID],Emp[hire date]),"Status","HIRE"),ADDCOLUMNS(FILTER(ALL(Emp[ID],Emp[termination date]),ISBLANK(Emp[termination date])=FALSE()),"Status","Terminate"))
    3. Done

    I don't have idea on "HR Churn visual" which seems a 3rd party visual. You can tweak the steps in the visual accordingly.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

bbreitenbach

 

You're welcome. :)

 

If there's no further questions, to close this thread,  you can accpet the suggestion(s) that help as solution.

beginpowerbi's avatar
beginpowerbi
New Member
8 years ago

Sorry for bringing this thread back to life.  This solution worked perfectly for me.  I'm wondering how I can calculate the total number of employees over time to add it as a secondary axis line chart?  For example, if a new company started with 5 employees in 2016, then in 2017 they added another 10, but lost 3; the line would chart at 5 in 2016 and then 12 in 2017.