Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |