Expression for colour by measure

[ronman10]

Hi Guys,

I have 3 different measures representing my data and I am looking am looking for an expression to add different colors to my bar chart through an expression. Any help would be appreciated.

I have sales data from 2015-2018 and wanted to add growth rates over the years as a KPI. How can this be achieved through an expression? Please advice.

Regards,

Rony

[big_dreams]

can you provide sample qvf??

Regards,

[aslam24196]

Go to the expression tab, click on the desired measure. There will be a '+' icon. Click Background Color and and give a desired RGB() Function.

You can also give basic colors as Function like Red() ,Green(), Black().

[aslam24196]

or if you are looking to change the color based on value like red for low, yellow for normal and green for high. you can give if conditions in the same Background color expression box

[vishweshwarisun]

Hi,

to give the colour by measure you will have to add the expression in the master item.

[ronman10]

Max,

I have started a new discussion with the same subject line and have added a sample qvf there. I am not getting the advanced editor option while replying to you here.

Thanks,

Rony

[ronman10]

Hi Vishweshwari,

How do we do that?

[vishweshwarisun]

hi,

In the left hand side there is a master item you have to create a master measure with the expression which u have and give the colour according to your requirement

[ronman10]

Thank you Vishweshwari!

[ronman10]

Vishweshwari,

One more question. I have sales data from 2015-2018 and wanted to add growth rates over the years as a KPI. How can this be achieved through an expression?

Regards,

Rony