Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 .
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 .
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
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