Conditionally Hide SSRS Gauge Pointer

I built a gauge in SSRS and added 3 pointers.  Each pointer is based on a product's manufacturing group.

So, for example, there's a white pointer with an expression as the value:
=IIF(Fields!Manufacturing_Group.Value = "White", Fields!Total_Labor_Hours.Value, 0)

Open in new window

And a blue pointer:
=IIF(Fields!Manufacturing_Group.Value = "Blue", Fields!Total_Labor_Hours.Value, 0)

Open in new window

And a brown pointer:
=IIF(Fields!Manufacturing_Group.Value = "Brown", Fields!Total_Labor_Hours.Value, 0)

Open in new window

I don't want to see a pointer if the value is zero.  How can I conditionally hide a pointer?

LVL 44
zephyr_hex (Megan)DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperAuthor Commented:
I have a semi-solution.  It doesn't hide the gauge pointer, but it does make the pointer appear to be disabled:

disabled pointers

The way I achieved this was to change the Pointer Fill Color (and Secondary Color) to an Expression:
=IIF(Fields!Manufacturing_Group.Value = "Blue" AND Fields!Total_Labor_Hours.Value > 0,"CornflowerBlue",Nothing)

Open in new window

NOTE:  It wouldn't work if I did the reverse check:

=IIF(Fields!Manufacturing_Group.Value = "Blue" AND Fields!Total_Labor_Hours.Value = 0,Nothing,"CornflowerBlue")

I'll leave this question open in case someone comes up with a better solution.
Nico BontenbalCommented:
Setting the 'Width (percent)' property to 0 hides the Pointer. For example for the White pointer you can use this expression for the Width property:
=IIF(Fields!Manufacturing_Group.Value = "White", 15, 0)

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.