The value automatically changes when you enter a decimal number in the slice field

Question

Hello! I've encountered an issue while working in Power BI Desktop.

I've created a parameter with a numerical range: GENERATESERIES(0, 10000, 0.01). When I try to input a decimal number in a slice field, the value automatically changes after pressing Enter. I expect the value I entered to remain unchanged, but it is being altered, leading to incorrect calculation results.

My version of Power BI Desktop is 2.119.986.0 64-bit (July 2023).

I kindly ask for your assistance in resolving this issue and for advice on how to retain the entered values. Thank you for your attention!

vicky_ · Answer

https://community.fabric.microsoft.com/t5/Desktop/GENERATESERIES-not-selecting-certain-number-in-the-range/m-p/600346

the issue is that you have is a common sampling error issue with the generateseries function and the slicer. Unfortunately, there is no real solution for this yet.

anonymous · Answer

Hi&nbsp;Apos&nbsp;,
&nbsp;
Can you provide some screenshots of the error?
I can't reproduce your problem here.

&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

apos · Answer

hi&nbsp;Anonymous&nbsp;Choose in the slice settings - a single choice.Enter different numbers in the box and press enter - the result will change

Forum Discussion

The value automatically changes when you enter a decimal number in the slice field

3 Replies

Related content

Monthly Automatic Change

Decimal Precision

Automatics Refresh

data converted automatically to decimal numbers

Decimals automatically rounded