Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community.
I have a unique one today. I have a combo chart where I have buttons that activate/deactivate the expressions (Legend titles) accordingly.
When I click on any one of the expression buttons, the bars color change and I would like for them to remain consistent. I have persistent colors under the colors tab and I am also using an expression in the 'plus' expansion within the expression to hide data that is not pertinent to the illustration (aka future months from current month).
Any ides on how I can maintain the color scheme even as the buttons are clicked?
Thanks in advance team.
Thanks for your reply Sergio.
I ended up using the Background color effect from the expression to resolve and it works fine. I modified the existing Set Analysis expression into a if statement.
=if(YearMonth>MonthStart(Today()),White(),RGB(77,167,65))
I then added a Condition for calculation:
=vGlidepath='Declared' or vGlidepath=''
Thanks...
Hi,
If you use a table color with Color field, youn can write as expression background color :
Only({<Color=>})
Thanks for your reply Sergio.
I ended up using the Background color effect from the expression to resolve and it works fine. I modified the existing Set Analysis expression into a if statement.
=if(YearMonth>MonthStart(Today()),White(),RGB(77,167,65))
I then added a Condition for calculation:
=vGlidepath='Declared' or vGlidepath=''
Thanks...