Forum Discussion
Numeric Range Parameter Issue
Whenever I create a New Paramater - Numeric Range (Whole Number) with:
Minimum Value: 0
Maximum Value: 1,000,000
Increment: 1
Default: 0
Slicer Type: Single Value
I get an error while inserting a number in the single value input field. For example if I enter:
1000 and hit enter, output is 999
2000 and hit enter, output is 1998 ..
Any fix to this issue?
Thanks
this is due to sampling of the what-if parameters (more than 1000 values):
https://community.powerbi.com/t5/Desktop/What-If-Parameters-Rounding-Crazy/td-p/993836
You can try creating the table in M, that should work fine:
let Source = {1..1000000}, #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Parameter"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Parameter", Int64.Type}}) in #"Changed Type"
1 Reply
this is due to sampling of the what-if parameters (more than 1000 values):
https://community.powerbi.com/t5/Desktop/What-If-Parameters-Rounding-Crazy/td-p/993836
You can try creating the table in M, that should work fine:
let Source = {1..1000000}, #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Parameter"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Parameter", Int64.Type}}) in #"Changed Type"