Bar chart color help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have a bar chart with

1Dimension : Category

2Measures :  =Sum({<Year={$(=Max(Year))}>}sales)

                    =Sum({<Year={$(=Max(Year)-1)}>}sales)

I have to apply below specified colors for each bar.

I have tried color by expression based on dimension like below.

=if(Category='Low',RGB(0,0,0),

if(Category='High',RGB(255,0,0),

if(Category='Medium',RGB(128,128,128)

)))

By the above expression 2017 and 2018 High bars getting red color but need to show 2018 High  bar as red and 2017 High bar as orange.

Please help me on this. Please find the attached app.

Thanks in advance.

[Silambarasan1306 · Accepted solution]

Given the solution in the attached application,

this may be help you. ! !