Forum Discussion

Jhadur's avatar
Jhadur
Helper I
2 years ago
Solved

How to Change Legend Labels

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. 

 

              

 

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

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

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

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