If an entry in a row is blank (null) can I set a default value?

[Anonymous]

I have a table that has one column that sometimes has blank (null entries). Sorry for blocking out a lot of the entries in the table but I don't want to share private data which is understandable I hope. However, as you can see below, (where the red arrow is) there are two blank entries in the bottom two rows in the Technician column. How would I be able to set that to a default string called "Unassigned"?

So instead of it coming up Blank in my analytics, as you can see below, it will show up "Unassigned" instead of the purple being blank? 

I know there are some things you can change for visuals on the Analytics screen, but I can't change it on this one when it comes to being legend values, it won't allow me. That would be a simple solution if that could somehow be done but I've looked into it and saw no solution, unless I haven't looked hard enough?

Any help would be appreciated. 

[Tahreem24 · Accepted solution]

You can create below Column:

New Column = If( Table [Technician] = blank(), "Unassigned", Table[Technician]) 

[Anonymous]

Thanks for the reply, when I tried to create a new custom column it said the if statement wasn't recognised?

[Tahreem24]

Do create that mentioned column using DAX not in Power Query. 

[Anonymous]

Thank you! Works a charm.