Color for Dimensions

[beck_bakytbek]

Hi Folks, 

i got a Situation, where i am using 1 Dimension (Month) and 3 Expressions:

Dimension: Month

3 Expressions:

2016: Sum({<Year= {'2016'}>}[Net Income])

2017:Sum({<Year= {'2017'}>}[Net Income])

2018:Sum({<Year= {'2018'}>}[Net Income])

all this data i have implemented  and grouped in the bar-Chart, my Question is, how can i give to any Expression the color-type, i mean:

2016 =green, 2017 = red, 2018 = yellow,

i tried to resolve but i did not achive any results, because the bar-Chart gives automatic standard-Colors to Expression, if you use one Dimension and a few expressions.

does anybody have any idea?

Thanks a lot

Beck

[Neymar_Jr]

Hi,

Try adding the measures to Master items. There you would find the option of Measure color, which enables us to color measures differently.

Thanks,

RT

[Somasundaram]

Hi,

we can able to achieve using background color properties in expression. 

=If ( year='2016' ,RGB(123,123,123), If(year='2017',RGB(321,321,321), RGB(123,123,123))

Hope it may help.

Thanks

[beck_bakytbek]

Hi Rajesh

what do you mean ? as i know, it is possible to use only one Expression in master item or am i missing something?

[Neymar_Jr · Accepted solution]

You will have to create 3 master measures and give them the appropriate colors and then use them in the chart. 

[beck_bakytbek]

Hi Somasundaram

thanks a lot for your responce, but it is not possible

[beck_bakytbek]

i tried, but no results

[beck_bakytbek]

Hi Rajesh,

your Suggestion is a Right solution, i overlooked some Settings in Color, thanks a lot for your help and time