Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 insert...
Need Help
Stachu's avatar
Stachu
Community Champion
3 years ago

this is due to sampling of the what-if parameters (more than 1000 values):

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if#considerations-and-limitations

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"