Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
i have barc hart with dimension trend 13 month, I want to change color of Bars as per dimension.
with expresion :
=if([Main Product]='Group 1',blue(255),
if([Main Product]='Group 2',red(255),
if([Main Product]='Group 3',green(255))))
and i have filter pane in jun 2023, so why the color expresion just apply ini jun 2023 not in all trend 13 months
Thanks for your help.
Seems like it would be easier to define Master Item colors rather than do this?
In any case, I believe that since you've selected Jun 2023, none of the other months are in the Possible data, and as such, none of them are associated with available values for Main Product. This means that the result of your if() formula will be null for all of those values.
You could wrap the entire expression in a set using Only() and it'll probably work. But I'd still suggest using the Master Item colors instead.
Only({1} if([Main Product]='Group 1',blue(255),
if([Main Product]='Group 2',red(255),
if([Main Product]='Group 3',green(255)))))
Hi... thanks for your help
thanks for your suggest for use master item colors and its more simple
Seems like it would be easier to define Master Item colors rather than do this?
In any case, I believe that since you've selected Jun 2023, none of the other months are in the Possible data, and as such, none of them are associated with available values for Main Product. This means that the result of your if() formula will be null for all of those values.
You could wrap the entire expression in a set using Only() and it'll probably work. But I'd still suggest using the Master Item colors instead.
Only({1} if([Main Product]='Group 1',blue(255),
if([Main Product]='Group 2',red(255),
if([Main Product]='Group 3',green(255)))))
Hi... thanks for your help
thanks for your suggest for use master item colors and its more simple