Color Coding for each Measure in a Bar/Line chart

[lightsection]

Is there a way to assign specific colors to each measure in a bat chart ? It would really great if someone can help on this.

Thanks,

[rohitk1609]

Hi Light,

You can't set a specific color any field or measure ,Yes what you can do you can set to multi color but you can't set as red is for field 1 or by your choice it will be set by automatically  or you can set color by values i.e less than 100 will be red , above will be green.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

[Gysbert_Wassenaar]

Not yet. You'd have to use a dummy dimension and single measure that uses a pick-match combination or if-statements. See this blog post for an example: Use Case for ValueList Chart Function

[lakshmikandh]

Hi Light,

As mentioned by gwassenaar‌ using if or pick match statements in color by expression.

You can set a specific color to any dimension member of the Chart i.e if you have Branch as field and North,South,West,East as values you can set each one different color.

Thanks,

Lakshmikandh

[shraddha_g]

if you have 2 measure as Actual and Budget then you can create a dimension by using Valuelist as Valuelist('Actual','Budget').

In Measures Section Use it as pick(wildmatch(Valuelist('Actual','Budget'),'Actual','Budget'),sum(Filed_For_Actual),sum(Field_For_Budget) )

In Color by Expression :

pick(wildmatch(Valuelist('Actual','Budget'),'Actual','Budget'),red(),green())

I hope this is helpful.