Color Formatting in Charts

[Anonymous]

Hi,

I want to conditionally format a bar/pie chart, I am using the following formula but it's not working

if([Recommendation State] = 'Closed', Green()) and if if([Recommendation State] = 'Open', Red()), if([Recommendation State] = 'Half Close', Yellow())

Can you please help? What am I getting wrong and where should I put this?

Thanks,

Sunny

[Anil_Babu_Samineni · Accepted solution]

Try some thing like below

if([Recommendation State] = 'Closed', Green(), if([Recommendation State] = 'Open', Red(), if([Recommendation State] = 'Half Close', Yellow())

Or

Pick(Match(Only({<[Recommendation State]>}[Recommendation State]), 'Closed', 'Open', 'Half Close'), Green(), Red(), Yellow())

Or

Pick(Match([Recommendation State], 'Closed', 'Open', 'Half Close'), Green(), Red(), Yellow())

[Anonymous]

Thanks a lot Anil