Removing Leading Zeros from Parameter in Paginated report

[Anonymous]

Hello,

I am trying to find a way to remove leading zeros from parameter in paginated report.

I have the same column used in table and I was able to remove 0s by providing "Cint" function in column expression (= Cint(Field...)).

Is there any way I can remove those 0s from parameter? Or can anyone help to write a DAX code to remove 0s while preparing the dataset? 

[Anonymous · Accepted solution]

@Anonymous 

If you used the column in the query as parameter, you can remove those 0s with Text.Trim() in Power Query.

For example: 

Copy and Paste the full code to advanced editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjAwAoJEpVgdENvAwDhVKTYWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
     #"Trimmed Text" = Table.TransformColumns(#"Changed Type",{{"Column1", each Text.TrimStart(_,"0")}})
in
    #"Trimmed Text"

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.