Without using an alternative measure i have tried the coloring
dimension 1: name
dimension 2: ValueList('Value 1','Value 2')
if(ValueList('Value 1','Value 2') = 'Value 1',sum(Value1),
if(ValueList('Value 1','Value 2') = 'Value 2',sum(Value2)))
color by expression:
if(ValueList('Value 1','Value 2') = 'Value 1' AND sum(Value1)> 2, Green(),
if(ValueList('Value 1','Value 2') = 'Value 2' AND sum(Value2)> 2, Green(), RED()))
Will this help you?? You can explore the valuelist function too it will be helpful in such scenarios
unfortunately that's not exactly what I was looking for. I was aware of the valuelist function and how to use this to achieve what you mentioned.
I wanted to get a visualisation in which the user can chose which measure to see. In your case every measure would be shown at the same time.
I know a possible way would be to use variables, but i wondered, if it is also possible using alternative measures.
didn't know about this function, seems very helpful thanks!
But this won't save my problem, because I want to colour the bars depending on what measure I chose.
If i write something like this:
if(column(1) > 100, green(),
if(column(2) > 3, green(),red()))
if i chose the second measure this measure will be painted green() if my first measure is higher than 100.