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

 

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.