Conditional palette using dimensional measures

[pka55555]

Hi folks,



We have a combination chart which has Bar as Measure1, there is also a horizontal baseline within the same query. I am trying to achieve conditional palette based on condition like this, if measure1>baseline value make the color of bar to brown, else grey.

Here is what i tried:
1. Created advanced conditional palette with condition measure1>baseline; Error: If the item exists in a query but is not referenced in the layout, add it to a property list
2. Added measure1 and baseline as properties of chart node item, Error: 'measure1' cannot have another measure as property.

Please let me know if anyone know the solution.

Thank You!!