Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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:
Proud to be a Super User!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.