Controlling Colors in a Stacked Bar Chart

[vvira1316]

Hi,

I've situation where an agreement table contains different columns having multi pick list values (over several hundred columns). I'm able to display them in a stacked bar chart. The multi pick list values for these columns are different.

What that means is say for

Column1 Possible values can be Value1, Value2, Value3,...,Value10

Column2 Possible values can be Value21,Value22, Value23

ColumnN Possible values can be ValueN1,ValueN2, etc.

Above information is contained in "AT_DataDictionary" Table and "Picklist Values" Column found in screenshot below,

In actual agreement fact data not all pick list value for each column may have been used

i.e.

Agreement1 - Column1 - Value1, Value3, Value7, Value9

Agreement2 - Column1 - Value2, Value4

Agreement3 - Column1 - Value1, Value2, Value7

Above information is contained in "AT_NotNull_N_ColPickList" Table and "ColPicklistValues" Column found in screenshot below,

My Data model is as seen in screenshot below

The stacked bar chart for this information can be seen in screenshot below.

I will like to control the bar color of each pick list value of each column if possible.

Thanks,

Vijay