Visualize large data model of decimal data mixed with text (n/a, n<10)

Boetheus,

If you want to replace only "N/A" and "N<10" with null, try this:

  RemoveText = Table.TransformColumns(
    Source,
    {"Total Pct Met", each if List.Contains({"N/A", "N<10"}, _) then "" else _}
  )

If you want to replace all text values with null, try this:

  RemoveText = Table.TransformColumns(
    Source, 
    {
      "Total Pct Met", 
      each 
        if 
          let
            result     = try Number.From(_) otherwise "Text", 
            resultType = if result = "Text" then "Text" else "Number"
          in
            resultType = "Text"
        then
          ""
        else
          _
    }
  )

Sample data:

Result: