Color a Bar in a chart a specific color

[jerryr125]

Hi - 

I have a bar chart displaying two different bars for each month:

Bar #1 Expression:

Sum({$<[ACCOUNTTYPEID]={'A'}>} ACCOUNTAMOUNT)

Bar #2 Expression:

Sum({$<[ACCOUNTTYPEID]={'B'}>} ACCOUNTAMOUNT)

I have the colors set 'by expression' with the following formula:

IF([ACCOUNTTYPEID]='A',rgb(0,109,51),rgb(186,18,0))

It does not work - colors all bars rgb(186,18,0) 

thoughts ? Jerry

[Kushal_Chawda · Accepted solution]

You can create the master measure for both the expression and in the property of master measure you can set the color . Now If you create the Bar chart with master measure it will automatically color the bar .

[dwforest]

This doesn't work because your graph does not use ACCOUNTTYPEID as dimension.

If you set ACCOUNTTYPEID as a dimension, the measure would just be SUM(ACCOUNTAMOUNT) and then your color code would work

[jerryr125]

correct - the funny thing is I had this already in the application - I added new data with new field names so therefore my master measure did now work!  All is good now - thank you for the reminder! Jerry