Thank you for share with me the link.
I found the script most suitable for me is below :-
If(ValueList('Oscars', 'Nominations')='Oscars', '#e1aa3d', '#ccc')
So i try using below expression :-But i get all red color.
If(ValueList('CY', 'LY')='LY', 'BLUE', 'RED')
I also try below exrepssion , i get all gray color.
If(ValueList('CY', 'LY')='CY', '#e1aa3d', '#ccc')
Where i go wrong ?
You would need to create an additional dimension with ValueList() and transform your multiple expressions into one checking the ValueList() to branch into the specific expressions to make this solution work.
But I missed that you were using a combo chart, which does not allow multiple dimensions AFAIK. You also need multiple expressions for the bar and the symbol display.
So maybe the proposed solution won't work in your setting anyway.
Sense is currently more limited than QV with regard to custom coloring. Maybe you can search for extensions with better custom color capabilities.