How to rename the legend while using an SQL Server Database

[Nursen]

Hi there,

I am using an online SQL Server Database in PowerBI for my dashboard. (So the buttons "New Column" or "New Table" are inactive, and can't be used.)

I have a pie chart using the value from one of the tables in the SQL, and the data for this column is either true or false.

However in my dashboard, "true" or "false" means nothing for the viewers. I'd like to rename these as "Done" and "Not done".

I used the following measure, but when I used it on my pie chart, I could not add this to the "Legend" part. I have no idea why. 

State =

IF (

    'Table1'[Status] = TRUE,

    "Done",

    "Not done"

)

Any idea how I can rename the values of my piechart?

[Joe_Barry · Accepted solution]

Hi @Nursen 

It seems that you are using a Direct Query connection to the SQL Server, is Using the Import an option? This will open all features within Power BI.

Otherwise adapt your select statement in SQL

SELECT 
CASE WHEN [Status] = TRUE THEN 'Done' ELSE 'Not Done' END as "Status"
FROM 
Table1

 Joe
Did I answer your question? Mark my post as a solution!