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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Krcmajster
Helper IV
Helper IV

What If parameter bug and alternatives

I have a few What If slicers on my page. I have also a filter button for those slicers (bookmark on selected visuals, so on paramater slicers). And entering values in the boxes works fine, when done first time. However, when I reset them with the button I created, everytime I want to enter a number again in the box it goes back to default, so 0. With sliders it works but it does not work when entering number in the box. Has anyone else encountered this issue? 

 

Also, is there an alternative way to What If sliders, so somehting where you can add numbers to do what if analysis? They are powerful if they actually work, but they are highly unstable and don't work as thay are supposed to.

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @Krcmajster 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

 

Best Regards

Maggie

@v-juanli-msft  Paramter was created as you did it but I needed to ajdust the measure for the problem what-if has, adding wrong values from what is entered

 

so this is the measure

 

 
par2 = Union(GENERATESERIES(0, 1000, 2),

GENERATESERIES(1, 1000, 2),

GENERATESERIES(1001, 2000, 2),

GENERATESERIES(1002, 2000, 2))
 
v-juanli-msft
Community Support
Community Support

Hi @Krcmajster 

Assume you create a parameter as below:

1.png

But you enter "1.3" in the box, it would return to 1,

as the what-if parameter is of "whole number" data type and it accept the increment of 1.

 

Please share me how you create the parameter and which number you enter in the box.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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