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.

bbreitenbach's avatar
bbreitenbach
Frequent Visitor
10 years ago

Eric,

 

Thanks for the suggestion to use a calculated table.

 

I changed the table to:

HRChurnTable = UNION(ADDCOLUMNS(ALL(EmpComp[EecEEID],EmpComp[Last Hire Date]),"Joined", 1, "Left", 0), ADDCOLUMNS(FILTER(ALL(EmpComp[EecEEID],EmpComp[Termination Date]),ISBLANK(EmpComp[Termination Date])=FALSE()),"Joined", 0,"Left",-1))

 

and did the graph summing the "Joined" and "Left" columns. That gave me positive and negative numbers on the clustered column chart.

 

Thanks again!

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.