Forum Discussion
Solved
Rename labels of sql values
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,...
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.
tjd
Impactful Individual
Impactful IndividualYou 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).
gipilusoResolver II
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.