Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using expression for color. pick and match function were used. Expression as the following:
pick(match(DRCNonSecList,'Corporates','Local Governments','Sovereigns'),RGB(204,102,119),RGB(68,119,170),RGB(26, 188, 156))
Seems to work fine until I click on other dimension like the following:
I think this is due to the selection of the colour
"pick(match(DRCNonSecList,'Corporates','Local Governments','Sovereigns'),RGB(204,102,119),RGB(68,119,170),RGB(26, 188, 156))"
is no longer valid. How do I make the color always valid in this case?
I was thinking to use
{<DRCNonSecList=>} to mix into pick and match functions so that regardless what dimension I am navigating to it will be always true and therefor the color will never change. However I can't figure out how this is possible. Please can any one advice?
You are right, try this
Pick(Match(Only({<DRCNonSecList = >}DRCNonSecList), 'Corporates', 'Local Governments', 'Sovereigns'), RGB(204,102,119), RGB(68,119,170), RGB(26, 188, 156))
You are right, try this
Pick(Match(Only({<DRCNonSecList = >}DRCNonSecList), 'Corporates', 'Local Governments', 'Sovereigns'), RGB(204,102,119), RGB(68,119,170), RGB(26, 188, 156))
Thanks Sunny!