Forum Discussion

dineshj's avatar
dineshj
Helper I
5 years ago
Solved

Giving blank fields a name

Hello! I have data in one of my columns in excel sheet that have blanks. On a pie chart in PowerBI, these blanks show up as "blanks". How can I change the name blanks to something else, like "unrate...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    dineshj Yeah, so then just right click the column in Power Query and choose Replace values. Leave the top one empty and the second one "unrated". Will replace null's (blanks) with "unrated".

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKkpNUdJRMlSK1YlWSi9KTc2D8+CMpJzSVAgnFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", Int64.Type}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","","unrated",Replacer.ReplaceValue,{"Column1"})
in
    #"Replaced Value"
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have a simular issue, I have a Spreadsheet that People enter data into for projects when they are assigned, at times these get entered but not assigned.  Want to put "Unassigned" in the Empty Visual. 

It reads like this. 

Project          Resource: 

Build 1          John Doe

Build 2          Jane Doe

Build 3          Jeffery Doe

Build 4                                <-- Blank - want these to read Unassigned

Build 5           Beckie Little