On a Bar Graph - How do I change the colour for each to my own selection?

[publication1]

Hi there I've tried a few ways to just do the most simple method to change a colour on a bar graph.

I have 3x (Heights) I want the first to be GREEN seconds to be ORANGE and third to be RED.

How is this not possible ?

[felipedl]

Hi,

If you always have 3 bars, you can do it by using:

if(RowNo()=1,red(),if(RowNo()=2,blue(),green()))

That will always give for the first bar red then blue and then green.

[Anil_Babu_Samineni]

What is 3x here?

[publication1]

Three values(heights)

[publication1]

Thanks, this did work and was a start however i need it like the attached image if you understand 🙂

[Anil_Babu_Samineni]

Create each measure in "Mater Measure" with color and they apply those measures in report. There is no other way until unless If you go with extensions.

[publication1]

Okay im happy to try this, do you have a guide handy I can follow step by step please ?

[Anil_Babu_Samineni · Accepted solution]

What ever you have applied in the chart, Let's assume

1) Sum(Sales)

2) Sum(Profit)

3) Sum(Loss)

Then, In the left side you can see "Master Items" --> Measures --> Create New --> Provide Sum(Sales) with color

vice versa for all three. Then, Use measure as what you created in the master item.