Forum Discussion
Waterfall Chart for Hires and Terminations
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
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.
8 Replies
- 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 TerminationsHi 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.
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 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.
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-...
Want faster answers? 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.
Hi sureshg2498,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
thank you.
Thank you so much. Issue has been resolved.
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.
