Forum Discussion
Advanced Editor - Filtering Columns
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.
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
1 Reply
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