Any way to have a slicer default to unselected?

[Anonymous]

Is there anyway to have a slicer default to no selected values before a user selects the data? I know there is an option for all, but I currently have a visual that pulls in alot of data (to the point where pulling all data points crashes desktop) and I would rather not have the default data point be the first item in the slicer.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a measure like:

Measure = IF(ISFILTERED('slicer'[column]),1,0)

Then add this measure to visual filter and set value = 1.

When there's no data selected in slicer, the measure will return 0 and hide all data.

Best Regards,

Jay

[amitchandak]

@Anonymous , In power bi slicer , all selected and all unselected are same

You can use isfiltered or hasonevalue in your measure to check

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/