Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a bubble chart, in which the dimension is dynamic.
Dimension changes based on the straight table below selected.
So if i have 5 values in a bubble chart, then i click one bubble, it filters to the selected value but the bubble color changes.
But i want it to be the same color as before.
How can we do that?
Hi
you can fix the colour using the function RGB in the background color
Expand the dimension to see the option back ground colour
Thanks
Padma
Hi,
Thanks for reply,
But my dimension is a variable, which updates based on selection of button below in the tool.
I have around 10 dimensions which changes in the bubble chart based on button selection below.
I guess i cannot include RGB for those dimensions.
HI
Please see the example: In my example I have fixed the colours for the dimension Fiscal Qtr if it is 51 or 52 else I have a different colour. This background colour should be set up in the expression not the dimension as I mention previously
if(Fiscal_Qtr=51,rgb(132,32,252),
if(Fiscal_Qtr=52,RGB(256,56,250),RGB(67,67,250)))
Thanks and regards
Padma
Hi,
Thanks for the reply.
I have around 10 dimensions in the chart and 100's of values in those dimensions.
So i cannot hardcode values in the background color expression of dimension or expression.