Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Headcount Changes in Waterfall Chart

I'm trying to create a Waterfall visual that shows Hires and re-hires as "Increases" Terminations and retirements as "Decreases"   My source data is an Excel spreadsheet showing the names of em...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thank you for responding.

     

    I found another way that works as well:

     

    • Edit Queries
    • Add Column Tab
    • Add Conditional Column
    • Name the new column Headcount Change
    • Tell the formula to treat Hires and Rehires as 1
    • Tell the formula to treat Terminations and Retirements as -1
    • Close and apply
    • In the Report page, click on the Waterfall chart to Sort by Headcount Change

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

You could add a measure to sum the amounts with the correct sign.

 

Headcount Change = SUMX( 'Headcount Changes' , IF ( 'Headcount Changes'[Type] IN {"Hire", "Re-Hire"},1,-1))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you for responding.

 

I found another way that works as well:

 

  • Edit Queries
  • Add Column Tab
  • Add Conditional Column
  • Name the new column Headcount Change
  • Tell the formula to treat Hires and Rehires as 1
  • Tell the formula to treat Terminations and Retirements as -1
  • Close and apply
  • In the Report page, click on the Waterfall chart to Sort by Headcount Change