Forum Discussion

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi Anonymous ,

 

You can create calculated column  like below and add it to the legend of visual.

legend_ =
IF (
    test[ rate] = "A",
    "Good",
    IF ( test[ rate] = "B", "Average", IF ( test[ rate] = "C", "Bad" ) )
)

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi v-henryk-mstf 

    Thank you for your reply.

    But what I want is when 2022 is selected (select alone or select both 2021 and 2022) the legend is (Good, Average, Bad),

    When it is not selected, the legend is A,B,C