Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, I looking for way to make a great forecast of sales which is based on expenses (with the possibility to adjusting by "what if").
That what I'm looking for is
1. Best forecast tool that would show me not only a forecast as the one in visual settings, but forecast could be:
- used with other dimensions
- could be adjustable by changing based values, for example, expanses
- be marked as forecast but also, have info about the accuracy of the forecast by showing the gap between real data (by the time) and forecasting one.
2. A way to change forecast by "what if" funcion, including changing expances and ajust sales or promotions in selected data
do you know some good tools to recive it or even some guides for it?
Hi, @Witold
If you have time data in your data source, maybe you can use the forecasting feature in PowerBI 'Analytics pane'.
Best Regards,
Community Support Team _ Eason
Hey, I try it as a first solution, unfortunately, it does not meet my expectations, it's impossible to drill down/drill-up. I cant work with this, it's impossible to convert that into the real dimension, and hence I cant put a for example percentage growth of forecast in case of... sometinhg. Looking for other solutions
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |