Scatter Chart - Hide some bubbles

[lylererger]

Hi Community!

Maybe someone faced that problem before.

I've got scatter chart with few dimensions, arrows directions shows conditions of the bubbles for the previous period.

Question: Is that possible to hide the bubbles of the previous period and how to do that?

P.S.: Demo in attachment.

Thanks in advance.

[adamdavi3s · Accepted solution]

You could mess around with the bubble and text colours using something like =if(Period='01.01.2016',argb(255,255,255,255))

Not sure though, might just take some playing with

[lylererger]

Thanks. It's the righl logic. But the legend is going gray.

Maybe any ideas how to solve that problem?

[lylererger]

Use the ColorMix functions.