Forum Discussion

power-bi-noob's avatar
4 years ago
Solved

Change values for legend

Is it possible to change the value names in a visualization for the legend?

 

 

The place I'm pulling my data from uses the terms "available" and "claimed" in place of what would be considered a published course versus an unpublished course. I was successfully able to change the value of the column name from "workflow_state" to "Status", but I can't figure out how to change "available" to "Published" and "claimed" to "Unpublished".

 

 

  • power-bi-noob 

    you can simply create a new calculated column in your table like below and then use this new column in your legend. You can customize the below if condition as per your needs

     

    Legend = if (table[status]="new york", "Published", "Unpublished")
     
     

2 Replies

  • negi007's avatar
    negi007
    Community Champion

    power-bi-noob 

    you can simply create a new calculated column in your table like below and then use this new column in your legend. You can customize the below if condition as per your needs

     

    Legend = if (table[status]="new york", "Published", "Unpublished")
     
     
  • Still not quite sure how to use the formula editor, so I used the visual editor to add a conditional column. Your tip put me on the right track though. Thanks!