How to Change Legend Labels

[Jhadur]

I have created this visualization based on information in an imported excel data files. I would like the legend labels to display as Green Amber and Red instead of 10, 20, 30. How can I do that? I feel that this can be done through the relationship function but have no idea what needs to be done. Information is being pulled from the Overall Status column. 

              

[rajendraongole1 · Accepted solution]

Hi @Jhadur - you can display the legend with colors by creating a calculated column as below:

StatusLabel = SWITCH(

    [Overall status],

    10, "Green",

    20, "Amber",

    30, "Red",

    "Unknown"

)

use the status label in legend , it should display the colors instead of numbers. 

Hope it works , please check

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!