Forum Discussion

Jferrell's avatar
Jferrell
Resolver I
6 years ago
Solved

Query filters

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???
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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.

Jferrell's avatar
Jferrell
Resolver I
6 years ago

= 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's avatar
Jferrell
Resolver I
6 years ago

Anyone have an answer? Thank you.

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    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.