Visual should blank when select more then 1 value in filter.

[Anonymous]

Hi all,
I have one situation where I need to hide chart data where user select more then one filter value.

Suppose we have one filter where we have Pc, tablet, smartphone if user select pc, visual should filter out and should show the pc data.
if user select more than 1 value in filter, visual should be blank.

I can not convert filter to single select coz I have other visual where this filter should works as multiselect.

Can we create measure to handle this scenario.

[m_alireza · Accepted solution]

@Anonymous ,

Try  creating this measure:

FilteredColumn = Calculate(IF(
 HASONEVALUE( 'Table'[yourslicercolumn] ),1,0 ), ALLSELECTED ( 'Table' ) )

 
Add the measure to the filter level visual of your chart and assign its value to 1 

If you select more than one value in the slicer, it will appear blank as below:

[johnt75]

You could do a check for only 1 item being selected by using HASONEVALUE. If its true then return your measure result, otherwise return blank.