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!!