Hi, I want to conditionally hide some bubbles (points) in a serie on a bubble chart (SSRS 2008). For the marker color, i used an expression like =IIF(some condition,"Blue","Transparent"). This works fine. When i use the same expression for the marker border color, the border still appears (in black). I tried =IIF(some condition,"Blue","no color"), but it still does'nt work. Any ideas? Thanks

Try "Transparent" instead of no colour

Hi, I tried transparent with same result.

Can you change the marker colur to automatic and see

I tried =IIF(some condition,"Blue","Automatic"), the borders are showing. If i put no condition and the color Automatic, the borders don't show for all bubbles, that's not what i want.

Hi yugmal, Thanks for your question. How about: IIF(some condition,"Blue"," #00ffffff")? Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi yugmal, Thanks for your question. How about: IIF(some condition,"Blue","#00ffffff")? Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi Sharp Wang, Does not work, the border are still showing.

Hello Yugmal, Try using Nothing instead of any color. Hope it helps. Thank you, SammieRS.Sammie

Hi Sammie, The borders are still there.

Hi yugmal, Thanks for your and other partner’s replies. I had reproduced your scenario on my local server, it works fine, the effects just like below: =IIF(1=2,"Red","#00ffffff") =IIF(1=1,"Red","#00ffffff") So please check your expression is there some mistakes. Hope it helps you. If your issue still exists, please feel free let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi Sharp Wang, In your example, on the first graph the square are as big as in the second graph. The border is still there but it is black. I redid your example but i set the color of the marker to red and the color border with this expression: =IIF(1=2, "Blue","#00ffffff") When the condition is true the border is blue, when it is false the border is black.

Hi yugmal, You are prudential, thanks for you pointing out this problem that I had ignored. As you said, it is really displays “black” when we give it no color, I have researching the root cause of this issue in Border color. For your requirement, when I replaced "#00ffffff" with “White”, it represented the effects just like these: =IIF(1=2,"Red","White") =IIF(1=1,"Red","White") Hope it can help you reaching the target. If the problem still exists, please let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi Sharp Wang, What i am trying to achive is to hide completely certain points (values). I use transparent for the marker color and this works. But it does not work for the border color. If i use the same color has the background, like you suggest, when the border crosses a grid line or another point (bubble), it will show. Thanks for your help.

Hi yugmal, Thanks for your reply. For Marker Color: =IIF(1=1,"Blue","Transparent") For Maker border Color: =IIF(1=1,"Blue","White") For Marker Color: =IIF(1=2,"Blue","Transparent") For Maker border Color: =IIF(1=2,"Blue","White") Hope it helps you. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi, I tried transparent with same result. du hoc|du hoc singapore|noi that fami

Hi vubasu, Thanks for your reply. My meaning is that: for Marker Color, you using =IIF(1=1,"Blue","Transparent"), for Maker border Color, you using =IIF(1=1,"Blue","White"). I guess it caused by design, when we specify Transparent in Maker border Color, it has no effect. However, when replace Transparent with White, it will help us reach to the target. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.