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?

bbreitenbach Try to use a calculated table following below steps. The dataset is as below 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")) 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.

HR Churn visual in HR Sample | Microsoft Fabric Community

4 Replies

Eric_Zhang
Microsoft Employee
10 years ago
bbreitenbach

Try to use a calculated table following below steps.

The dataset is as below

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"))

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
  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
    Microsoft 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.

Forum Discussion

HR Churn visual in HR Sample