Show blank visuals if no value selected in Slicer

[Anonymous]

Hello All,

I am trying to build a report on perticualr data which is having mutliple project id's.

I have used Chicklet slicer for selection of projects and according to that i tried to build a report.

I would like to know that, can we show blank visuals if no project id is choosed rather than showing all cumulative values of all the projects when no project id is choosed(by default feature).

I have tried below dax measure

Slicerselection = if(calculate(distinctcount('tablename'[PROJECTID]),allselected('tablename'[PROJECTID]))=1,"Y","N")

and i put this measure in every visuals, Visual Level Filter and mentioned Show items when the value is: Contains Y.

Its working fine but for only when i choose single project id.

If i choose multiple project id then it's not working, shows blank visuals.

Please suggest me.

Mohan V

[himanshu56]

You can use blank() function

CALCULATE (
IF (
CALCULATE ( tablename[projectid] ) = BLANK (),
0,
CALCULATE ( tablename[projectid])
)

Thanks,

Himanshu