Hiding an object with a selection without using a text box for hiding

[#1]

All,

I would like to select a "Goal" in the Goals listbox, as so:

and change this layout

to this layout

Does anyone know how I could accomplish this?

Thanks in Advance,

Preston

[tamilarasu · Accepted solution]

Hi Preston,

You can use below expression in Conditional show property of the chart. Check the attachment and adapt the same for all charts.

=Count(DISTINCT {<Type={'Measure'},ID={'1.2*'}>} [Measure Name])

[uacg0009]

Hi Preston,

And I also think that you can create a variable, for example named v1,

then using :

v1=if(Goals='Mission Specific',1,0)

then using the v1=1 then show the Mission Measures in condition.And 0 show another list box.

Aiolos Zhao

[#4]

Thanks Tamil for the solution! I really appreciate it.

Regards,

Preston

[#5]

Aiolos,

I never thought about using the variable, but I think I'll combine it with Tamil's answer above to really work some mags with what I'm trying to do.