Advanced Editor - Filtering Columns

[Anonymous]

i created a parameter "Company"  and i pass its value on the advance editor.

Here are the values of Company parameter:

All

Company1

Company2

Company3

Here is my script in advance editor:

let
Source = Table.Combine({Contact1, Contact2, Contact3, Contact4, Contact5, Contact6, Contact7, Contact8}),
#"Filtered Rows" = Table.SelectRows(Source, each ([Company] = Company))
in
#"Filtered Rows"

If i select the "ALL" value, i want to remove the filter and show all the values.

Is that possible? Please advise. 

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Based on my test, we can add an if condition in Advanced Editor to check if the value of Company parameter is All. There is an example for your reference.

let

    Source = Table.Combine({Table1, Table2}),

    appendtable = Source,

 

    #"Filtered Rows" = Table.SelectRows(Source, each [Company] = Company),

    result= if Company = "All" then appendtable

    else #"Filtered Rows"

in

#"result"

Through that we can get the result as below:

For more information, please refer to the pbix as attached.

https://www.dropbox.com/s/v7hbk2mrh2s1z8o/Advanced-Editor-Filtering-Columns2.pbix?dl=0

Your code can be updated as below.

let

Source = Table.Combine({Contact1, Contact2, Contact3, Contact4, Contact5, Contact6, Contact7, Contact8}),

    appendtable = Source,

 

    #"Filtered Rows" = Table.SelectRows(Source, each [Company] = Company),

    result= if Company = "All" then appendtable

    else #"Filtered Rows"

in

#"result"

Regards,

Frank