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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

What If Parameter - Slicer (single value) sticks on value and won't allow value greater than current

Hello,

 

I am using a number of what-if parameters, with one for a Gross Pay value. When I publish my report and ask colleague to test they are routinely experiencing an issue where they type in a number e.g. 2000, then cannot type in a higher number e.g. 2500 or anything > 2000. They can however type in a lower number, I have no idea why this would be happening and would appreciate any help or advice.

 

The tables within my dashboard are not related and the series for the slicer has an upper limit of 10000. If there's any more information I can provide please let me know. This has become a major issue and as mentioned, any help is greatly appreciated!

 

Kind regards

 

 

2 REPLIES 2
v-lid-msft
Community Support
Community Support

Hi @Anonymous ,

 

Does this issue only happen in the Power BI Service for some users? Could you please check the following setting of shared report?

 

14.jpg

 

Or if you mean the behaviour when you type 5000 the slicer will become 4995, Based on this thread: https://community.powerbi.com/t5/Desktop/Parameter-what-if-increment-error/m-p/669283#M321986

 

 This is currently by design, though we've been discussing a better experience when we're sampling data points

 

12.jpg13.jpg

 

If you mean other issue, is it reproducible in Power BI Desktop? Could you please try to explain the reproduce steps with our sample pbix file?


By the way, PBIX file as attached.


Best regards,

 

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

Hi @Anonymous ,

 

Is the user abble to select another value from the slider on the slicer, or is the problem also on the sliding bar?

 

Are you sure you don't have any other filter on your report?

 

Also check if is related with this issue that I had reported, try to test it out.

https://community.powerbi.com/t5/Issues/Slicer-between-value-when-pressing-ENTER/idi-p/425240?lightbox-message-images-425240=98006i3259F7C9DAC6EC59

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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