applying Colors in the bar chart

[#1]

Hi,

I would like to apply the color on the actual bar in the chart based on the budget value.

if the actual is greater than or equal to budget value, than the color of the actual bar is in green else its in red.

I  tried the expression, but its not working while using two dimensions.

kindly help me to resolve this issue.

thanks in advance.

thanks,

Gopinthan

[maxgro]

I think you can remove the dimension Trx_Flag and get the color

[consenit]

Hi there.

Try this expression for the background color and delete the field Trx_Flag from the dimensions.

if

(

  sum

  (

  {$<Trx_Flag={'Budget'}>}

  Expression1_Budget

  )

  <=

  sum

  (

  {$<Trx_Flag={'Actual'}>}

  Expression1

  ),

  Red(),Green()

)

[ecolomer]

is that?

[#5]

Hi,

Thanks for all your reply.

Please find the attachment, which shows the reason of the dimension required in the bar chart.

Thanks in advance.

[#6]

Hi Enrique,

I think this one is working. But I am not able to figure out changes you did.

If you don't mind, can you please explain me?

Thanks,

Aakash

[ecolomer]

Yes, this are the changes

[#8]

Hi,

Thanks for all your support.

Finally I got the solution, here with i attached the document FYR.

! !