Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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"
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"
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |