Forum Discussion

Nursen's avatar
Nursen
New Member
2 years ago
Solved

How to rename the legend while using an SQL Server Database

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?
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    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!

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    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!