What If Parameters Rounding Crazy

[lfrosales]

Created a Series from 0 to 75,000,000 with increments of 10,000.

In the slicer, I choose "single input" and type 7,140,000 which is in fact a value in the series described above. However, the display automatically roudns to 7,120,000 (why did it round down 20,000?).

If I type 7,150,000, it still rounds to 7,120,000.

If I type 7,160,000 it rounds up to 7,190,000.

Have played around with the increments with no success. Any help would be greatly appreciated.

[v-xuding-msft · Accepted solution]

Hi @lfrosales ,

It's caused that the range is too big and the numbers are being sampled. So not all value can be typed as single value.  It's a limitation of what if parameter, please review the following ideas and comment on them.

What-if Parameter Slicer Limitations
"what if" parameter - turn off sampling so all numbers are generated in a range

[Greg_Deckler]

I can confirm this. Seems like a bug.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".