Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have a bar chart which features market-share value of different products. Can i set an expression so that i get all the bars for the products having market share value more than a particular value say 15,000 in one colour and the others in other?
Hi,
You can use the Background Color expression to change the color.
Hope the attached screenshot will helps you.
Regards,
Jagan.
Hi,
Hope the attached file helps you.
Regards,
Jagan.
Hi
Hope this attached file will be helpful for your requirement.
Regards
Ashok
Hey Jagan,
Thanks for replying, but could you please tell me how did you get that option of changing background colour in expressions for sales?
Hi
You just check the image file which jagan attached in this thread.
Its have the solution for your question.
Regards
Ashok
Hi,
Just expand(Click) the + symbol before the expression, you will find "BackgroundColor" below, click this and give the expression
=If(Sum(Sales) > 1000, RGB(0,0,255), RGB(0,255,0))
in Definition(Expression) textbox.
Hope this helps you.
Regards,
Jagan.
Hi Jagan,
This is not giving any results ☹
Hi,
Did you replaced this expression "Sum(Sales)" with your expression?
If possible attach the sample file. you can check the same in attached files by me and Ashok.
Regards,
Jagan.
Hey Jagan,
Thanks a lot for the help..it really worked!!