I just thought to share this implementation, as it may help others.We were having one requirement, where we want to change the color of the expressions in the line chart depending on the cycle option coming in the dimension. There were two cycle options, one was Customer and other is Area. When Customer is selected, the color values should come from excel sheet, which for other the color should come from color pallet.
Now, create a cyclic group, line chart with below Dimension and Expressions:
And color pallet as –
Now, when we save the chart, there will be no difference in the output color for any cyclic group selected –
As we want, that the color of the expressions should change as the Customer cycle is selected, and for other the colors should be from pallet, add below expression in the background color of the expressions:
The output will be –
Hope this small article helps. Please provide your valuable comments on same. !