Reply
Knoble
Frequent Visitor

Waterfall Forecast with Accuracy Percentage question(s)

I have a dataset that I need to create the following in Power BI.

Knoble_0-1729721750351.png

I built out the excel file and imported it like this, but now I'm feeling like I either didn't set it up accurately, or there is a step I am missing to get the percentages to look like the above (the forecast date is the forecast version and each group has to provide a fresh forecast each month).

 

Knoble_1-1729721834733.png

Knoble_3-1729721892717.png

 

This is the output I am getting, the up to 30 days out is matching, but everything else is wrong. I would appreciate any and all assistance.

I would also value your thoughts in how to establish a 30, 60, and 90 day slicer.

 

Thank you

 

 

1 ACCEPTED SOLUTION
3 REPLIES 3
v-xianjtan-msft
Community Support
Community Support

Hi @Knoble 

 

Sevenhills' reply shared a wealth of reference resources, did it help you solve your problem? If yes, please consider accepting sevenhills' reply as a solution, which is helpful for other users seeking answers to similar questions.
If you have any other questions, please feel free to contact me.

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It's good information, but it would have been nice to get a better walk through. 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)