Matrix table visualization empty until select any of the slicer in the report

[Anonymous]

Is it possible to have a an empty table unless a specific slicer item is chosen from the list of the slicer which i used in reprt? In other words, if a slicer item is not chosen, nothing in the table will apear, and then when any of the  specific slicer is chosen only the table wants to show data? In my report i used almost 5 slicer and matrix table having more tha 30 column values...With this is it possible?

[mahoneypat]

You can use HASONEVALUE() for that in an IF().  For example,

NewMeasure = IF(HASONEVALUE(Table[ColumnUsedInSlicer]), [YourMeasureExpression])

If more than one value exists (no selection), it will return blank.

Pat

[Anonymous]

This is image of my report...Here i used 4 slicers with lots of columns values in table.So , my requirement is   if any of the 4 a slicer item is not chosen, nothing in the table will appear else appear based on the selected values from any of the slicer...Is it possible?