I'm using Bar chart or combination chart build a chart for "actual" vs "budget" data,
I need to change "actual" bar color to be "green" when "actual">"budget", and change "actual" bar color to be "red" when "actual"<= "budget".
sample chart is in below attachment,
however, the conditional palette don't work, I tried lots of method, but can't find the right way to set the conditional expression.
pls help me for the conditional palette and conditional expression.
great thanks.
is your source dimensional?
You can try to tuple your default measure with Actual and Budget and then do the expression with those.
Thanks SDF, you are correct .
In my previous chart, Actual, Budget are two dimension element, so the conditional palette don't work.
When I have changed the Actual, Budget into two measures, and remove the default measure in the chart, the conditional palette could work now.
so Conditional Palette will work when you compare two measures, not two dimension elements.
the main idea is to compare items with values. ;)