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

[Boetheus]

I am relatively new with PowerBi. I have loaded and performed basic formating, cleanup and created visuals. I want to visualize some state wide school data where with over  90 columns of decimal data mixed with either N/A or N<10 or both. I need the data type to be decimal and not text. How I handle or represent the (N/A) and the (N<10) that exist in practically every column across the entire model?

[DataInsights]

@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: