Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a simple task although I can't figure out how to do it.
I have a bar chart with different measures and I want to color a bar based on the Measure used (NOT the value of the measure). So this is technically based on Measure name (easily done in Excel).
I could use the IF statement, but I don't understand how to refer to the Measure in the formula. Like if(measure = [Revenue], green(), blue()).
Is there a way to do it?
Thank you!
Use Valuelist() for dummy Dimension referring Measure
1st DImension : Dimension Field Name
2nd Dimension : Valuelist('Measure1','Measure2')
Expression:
pick(wildmatch(Valuelist('Measure1','Measure2'),'Measure1','Measure2'),
Expression for Measure1,
Expression for Measure2
)
Color by Expression:
pick(wildmatch(Valuelist('Measure1','Measure2'),'Measure1','Measure2'),
Color for Measure1,
Color for Measure2
)
Use Valuelist() for dummy Dimension referring Measure
1st DImension : Dimension Field Name
2nd Dimension : Valuelist('Measure1','Measure2')
Expression:
pick(wildmatch(Valuelist('Measure1','Measure2'),'Measure1','Measure2'),
Expression for Measure1,
Expression for Measure2
)
Color by Expression:
pick(wildmatch(Valuelist('Measure1','Measure2'),'Measure1','Measure2'),
Color for Measure1,
Color for Measure2
)
Brilliant
the original bar chart has only one Dimension, so this won't work, right?
UPDATE: solved