Waterfall Chart for Hires and Terminations

[sureshg2498]

Hi All,

We have a requirement to show the Hires and Terminations similar to the below chart. We want to show both Hires and Terminations in the Chart. Could anyone please help to create the below chart?

Joiners---Hires

Leavers---Terminations

Thanks for your help.

Thanks,

Suresh.

@Bibiano_Geraldo @rajendraongole1 @Ritaf1983 @danextian  @lbendlin @Ritaf1983 @bhanu_gautam

@MohamedFowzan1 

[v-saisrao-msft]

Hi @sureshg2498,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

thank you.

[sureshg2498]

Thank you so much. Issue has been resolved.

[v-saisrao-msft]

Hi @sureshg2498,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft]

Hi @sureshg2498,

Thank you @Shahid12523, for your insights.

Please provide sample pbix with the expected output that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? 

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Additionally, here’s a link to the official link on Waterfall charts in Power BI, which aligns with the requirement of visualizing hires and terminations:

Waterfall charts in Power BI - Power BI | Microsoft Learn

Thank you.

[danextian]

Hi @sureshg2498 

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

[sureshg2498]

Thank you for the reply Danextian.

Please find the below sample data. We want to show this data in waterfall chart. Thank you for your time and support.

Year	Hires	Terminations	Total Employees
2021	200	100	3000
2022	100	50	3050
2023	10	500	2560
2024	5	700	1865

[v-saisrao-msft · Accepted solution]

Hi @sureshg2498,

I used sample data to generate the output below and have also attached the pbix file for your reference.

Solved: Waterfall Chart - Set as total - Microsoft Fabric Community

Hope this helps

Thank you.

[Shahid12523]

- Use a Waterfall Chart visual
- Structure your data with:
- Start Balance (e.g., April: 3014)
- Positive values for Hires
- Negative values for Terminations
- End Balance (e.g., May: 2961)
- Set Start and End as Total bars
- Color-code: Green for Hires, Red for Terminations