How to change the color of differents column of a Bar Chart

[#1]

Hi guys,

I have a big issue in my Bar chart. It's setted as grouped and vertical.

As Dimention I have the months of the year, and as measures I have the total value of three years of sales (2013, 2014, 2015).

I'm trying to change the color of the year's columns on the chart.

I'm trying to set:

-2013's columns, intto grey.

-2014's columns into blue.

-2015 columns into yellow.

I tried this formula, but I changes all the cloumns of the chart to blue.

IF( Sum([2015]), yellow(), if( Sum([2014]), blue(), rgb(199, 199, 199)))

I would like to know what's wrong in my formula and if there is a better way to do it.

I attached a screenshot of the original chart( without the formula) and a screenshot with the formula to facilitate.

Thanks a lot in advance.

Best Regards,

Fernando

[reddy-s · Accepted solution]

Hi Fernando,

you can colour a bar chart/ Stacked bar chart the way you like to.

This possible by adding 2 dimensions and 1 Measure. Check the QVF attached for more details.

If you are facing any issues achieving this, please attach a sample QVF and I will help you achieve it.

Thanks and Regards,

Sangram Reddy.

[#3]

Hi Sangram,

your example helped me a lot and now my charts are colorful with the colours I needed.

Thank you very much.

Best Regards,

Fernando

[reddy-s]

Always Welcome!