Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

None option in a parameter

Hello, To simplify my problem, let's pretend that I am using accounts data. Each account has a type : A, B or C. I am using a parameter which filters my data according to these three types. To do ...
Need Help
Tips and Tricks
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

     

    Sure, you can use the exaple below.

    Parameter query.

    "none" meta [IsParameterQuery=true, List={"none", "A", "B", "C"}, DefaultValue="none", Type="Text", IsParameterQueryRequired=true]

    Table query 

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclSK1YlWcgKTzkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [types = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"types", type text}}),
    #"Filtered Rows" = if Parameter = "none" then #"Changed Type" else Table.SelectRows(#"Changed Type", each [types] =  Parameter )
in
    #"Filtered Rows"

    Hope this helps!

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

Sure, you can use the exaple below.

Parameter query.

"none" meta [IsParameterQuery=true, List={"none", "A", "B", "C"}, DefaultValue="none", Type="Text", IsParameterQueryRequired=true]

Table query 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclSK1YlWcgKTzkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [types = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"types", type text}}),
    #"Filtered Rows" = if Parameter = "none" then #"Changed Type" else Table.SelectRows(#"Changed Type", each [types] =  Parameter )
in
    #"Filtered Rows"

Hope this helps!

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

gtamir1's avatar
gtamir1
Helper I
4 years ago

Hi Mariusz I am also interested in the solution. What do I have to modify in my query to have a none option?

I dint have a list like in your example.

Thanks Giora