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 f...
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!

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!