Slicers showing data when nothing is selected

[Jessica_Ballard]

I have 2 slicers (one for year and one for region) and i have 2 charts (one showing number of deals per year and one showing number of deals per region). Selecting anything in either slicer filters both charts. However, If you do not click anything in either slicer (nothing is checked) it shows the same charts as it does when everything in both slicers is selected. How can I update my slicers so that nothing is showing in the charts until something is selected in at least one of the slicers. Both slicers are multi select and have the select all option turned on.

[v-chenwuz-msft]

Hi @Jessica_Ballard ,

You can use this measure to show no result unless select at least one of the slicers.

Measure =
VAR _R =
CALCULATE( ISFILTERED( 'Table'[Region] ), ALLSELECTED( 'Table'[Region] ) )
VAR _Y =
CALCULATE( ISFILTERED( 'Table'[Year] ), ALLSELECTED( 'Table'[Year] ) )
RETURN
IF( _R || _Y, 1, BLANK() )

Then put the measure in filter pane on this visual level and set show items is 1 as the screenshot show.

But "all" option  turned on and selected all will be recognized as not selected. Choosing one by one until all is ok

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Jessica_Ballard]

Thanks for this. Is there any way to get this to work and still be able to use the select all button? The region section lists over 100 countries and it would be a lot to have to select each one individually.

[amitchandak]

@Jessica_Ballard , On approach, is to create measure that do not have any value unless filtered

if(isfiltered(Table[Region]) || isfiltered(Table[Year])  , [Measure] , blank())

do this all measures or use this visual level filter

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