Forum Discussion
Visualize large data model of decimal data mixed with text (n/a, n<10)
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?
1 Reply
- DataInsights
Super User
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:
