Posted 6 December 2024, 11:53 am EST - Updated 6 December 2024, 4:41 pm EST
I used this switch case to display color based on conditional format but it does not work as expected. Codes input in the CustomPalatte of the chart.
=Switch( Fields!RATING.Value = “AAA”, “#00b6b2”, Fields!RATING.Value = “AA”, “#00667f”, Fields!RATING.Value = “A”, “#d1dbe3”, Fields!RATING.Value = “BBB”, “#009b86”, Fields!RATING.Value = “BB”, “#d2a02a”, Fields!RATING.Value = “B”, “#003865”, Fields!RATING.Value = “CCC”, “#eed9a9”, Fields!RATING.Value = “”, “#77c2ff”)
Please let me know a solution. Thanks