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.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

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

Jferrell's avatar
Jferrell
Resolver I
6 years ago

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

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

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

    • Jferrell's avatar
      Jferrell
      Resolver I
      6 years ago

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

      • 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))