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

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