I have 3 expressions
I need to apply colors by expression
Eg: 3 expressions
Sales
Quantity
Amount
In bar chart
If it is sales - green
Amount- red
Quantity- blue
Expression by color?
Create Master Measures shown in figures. there in Create Master Measure Window you will get option to assign color.
Use this Master Measures in Charts.
In Chart's Appearance Section, -> Colors -> you will get option to choose Library Colors
create these 3 Measures in Master Item. While Creating you will get a option to assign color to each expression
in colours tab try by meausre?
How you write in
Color by expression
In Color by expression you cant refer to measures Labels
Yes I know that.
But how to write. I don't have any field for those expression s
So I can't use pick(match
Let's consider
3 expressions
Sum(sales). - sales
Sum(quantity)-quantity
Sum(amount)-amount
you have to set Auto as Colors in the bar chart because the color for each measure is specified in master items.
Create Master Measures shown in figures. there in Create Master Measure Window you will get option to assign color.
Use this Master Measures in Charts.
In Chart's Appearance Section, -> Colors -> you will get option to choose Library Colors