topic Color a Bar in a chart a specific color in App Development

Color a Bar in a chart a specific color

jerryr125 — Fri, 03 Jan 2020 17:56:11 GMT

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

Re: Color a Bar in a chart a specific color

Kushal_Chawda — Fri, 03 Jan 2020 18:18:20 GMT

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 .

Re: Color a Bar in a chart a specific color

dwforest — Fri, 03 Jan 2020 20:23:42 GMT

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

Re: Color a Bar in a chart a specific color

jerryr125 — Sat, 04 Jan 2020 01:26:01 GMT

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