Parameter is changing the value of number entered

[Craigja123]

I need to have a parameter on my PowerBi - this is where the user will enter an Average Daily Volumn in thousands - so for instance 123.68.  

My paramter is this: 

ADV = GENERATESERIES(0, 9999.99, 0.01)

I assume that means we can start with 0 and go to 9999.99 in increments of 0.01.  I have the format as a decimal number with 2 decimla places.  When I enter 123.45 and click enter, it changes to 119.88 - why is the number changing and how do I make it stay the same?

[Craigja123]

What I eventually did was set up a parameter from 0-10 in 0.01 increments then multiplied it by 1 million.  This does not allow for the exact number to be input, but will allow PowerBI to calculate a ballpark figure, which is fine

[Craigja123]

I read you can only have something like 1,000 values - if I change it to a whole number and then multiply it that would work.  Just foud out my Average Daily Volume could be in thousands or millions - will I be able to do this?  I wonder if I need a multiplier button to say its 123 thousand or milllion

[Anonymous · Accepted solution]

Hi @Craigja123 ,

There is the following limitation when use parameter, please review this official documentation for more details. However, when you’re trying to generate a series from 0 to 9999.99 in increments of 0.01, that’s a total of 1,000,000 values, which exceeds the limit.

• Parameters can only have 1,000 unique values. For parameters with more than 1,000 unique values, the parameter values will be evenly sampled.

If you can create a value dimension table and create a slicer which apply the value field on it.

powerbi - Power BI - Add slicer for thousands and millions - Stack Overflow

Best Regards