Rename labels of sql values

[barakkor]

Hi,

I'm getting data from SQL with values (0,1,2 etc...) I would like to rename them on the dashboard to text labels. is there a way to create a rule or a new label for each value?

Thank you,

Barak

[tjd]

You could "Create Table" and add a column for the SQL values and another for the text names and then relate them via the SQL values column to the SQL table.  Then, insert the text names instead of the SQL values into your visualization(s).

[gipiluso · Accepted solution]

In case you don't have the chance to perform edit on SQL, you could:

• Create a custom columns in powerbi (model or report) or:
• Enter the Table in PowerBI containing the mapping and relate it to the sql column.