Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
StephenF
Responsive Resident
Responsive Resident

What if parameter changes my input - why?

Estimated Revenue = GENERATESERIES(0, 10000000, 1000)

 
I input 7600000 and the inputed value is changed to 7602000
 
Seems a serious bug?
 
I created a second one using Whole Number and added 7600000 the number changed to 7592000 within the input field.
2 REPLIES 2
amitchandak
Super User
Super User

@StephenF , that is because of what if  sampling , when large values are there.

 

Just create a manual table using this

Estimated Revenue = GENERATESERIES(0, 10000000, 1000)

 

and then try

 

refer

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if#considerations-and-limitat...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I've added an idea

 

https://ideas.powerbi.com/ideas/idea/?ideaid=2da29200-6ca0-ec11-826d-501ac5249847

 

I need to be able to input precise values in the millions.  This is supposed to be a financial services tool, very disappointing.

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors