Query filters

[Jferrell]

When I right click on filtered rows I can click on edit settings and make changes BUT when I cliock on another filtered row the "EDIT SETTINGS" is grayed out and I CAN'T clik on hat???

[jdbuchanan71]

Are you able to click on the gear icon next to the step?

[Jferrell]

That filter does not have the gear to the right.

[jdbuchanan71]

What is the text in the formula bar when you select that step?

[Jferrell]

Not sure what/where the text or formula are but I can right click and get options like delete, rename, properties, etc.

[jdbuchanan71]

The formula bar is highlighted in my screen shot below.  I am wonding what you see for that step:

[Jferrell]

= Table.SelectRows(#"Credit % Spent Filter", each [PO Required] <> null)

[Jferrell]

= Table.SelectRows(#"Added Custom", each ([#"Credit % Spent"] <> null and not Number.IsNaN([#"Credit % Spent"]) and [#"Credit % Spent"] <> -#infinity and [#"Credit % Spent"] <> 0 and [#"Credit % Spent"] <> #infinity))

[Jferrell]

Anyone have an answer? Thank you.

[jdbuchanan71 · Accepted solution]

You can modify the code directly in the formula line if you are wanting to change those filters.  I think the reason you don't see the gear is that the GUI for filtering only allows 2 basic filters and the filter that is applied in that step is mor complex that the UI can display.