Hide one value when another value is selected

[psk180590]

Hello all,

I have a dashboard where i would like to hide a particular Pie-Chart when an other value is selected.

Ex: Consider i have Product(as dropdown box) and Market(as Pie-Chart) values in my dashboard.

I'm now seeing both by default, but when a user selects a particular Product the Pie showing market results must disappear.

TIA!!

[sunny_talwar · Accepted solution]

Try a condition show expression like this for your pie chart on the layout tab

GetSelectedCount(Product) = 0

[Anonymous]

I think you should work on

Pie chart:

Properties..>Layout...>Conditional...>

[Anonymous]

At Layout insert condition:

if( SubStringCount( Concat(GetFieldSelections(Product),' '),'ProductName' )=0,1,0)

And at the ProductName, you can insert the value.

[psk180590]

Thanks All for the quick suggestions.

stalwar1‌ your suggestion worked for me.

I was trying with a Count(distinct) and the chart would disappear completely. But, now it perfectly suits my requirement.

Thanks Again!!