HR Churn visual in HR Sample

[bbreitenbach]

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/measures do I create for the HR Churn visual?

[Eric_Zhang · Accepted solution]

@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]

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]

@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]

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.