How to change the text for a value in a visual?

[Anonymous]

Hello there, I didn't think this would be too difficult but surprisingly I've spent a few hours on trying to do this. I've got a pie chart with a % of accounts there. I want to rename one of the values in the account column, as seen below:

I want to rename the "AA Unassigned" to "AA Queued". I thought there would be a quick way to change the visual value with a point and click, but it looks like a measure will have to be added? 

The Account column is in the RequestDetails table, if that helps. Any help would be appreciated, thank you. 

[amitchandak · Accepted solution]

@Anonymous , You need add a new calculated column

New column = if([Account] ="AA Unassigned" , "AA Queued", [Account])

[Anonymous]

Thank you, that worked very well