Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression which defines the background colour for a bar chart I have
if(wildmatch(Market, 'EMEA*'), RGB(141,170,203),if(wildmatch(Market, 'APAC*'), RGB(252,115,98),RGB(187,216,84)))
It works well, until i start making selections in the Market field whereby the can bars change colour. Obviously I don't want that to happen, i want to colours defined above to stay fixed for each bar.
How do i do this?
Hi Alex, It's strange, if you salect a maket the bars it other markests should disappear and keep those in the selected market with the colors you set.
I guess your dimension is showing values that can be in mero than one market or you an using an expression with set analysis, in both cases, a selection will change the 'market' vaues for some dimension values and that causes to change the bar colors.
Try using something like:
if(wildmatch(Only({<Market>} Market), 'EMEA*'), RGB(141,170,203),if(wildmatch(Only({<Market>} Market), 'APAC*'), RGB(252,115,98),RGB(187,216,84)))
That worked Ruben
thanks very much