Default Slicer to none selected

[DSwezey]

I have two slicers on a labor analysis page. One is for Employees and the other for Subcontractors.

I want to be able to filter from either Employees, Subcontractors, or both. If I filter both that works fine, but here is where I am running into issues.

If I select 1 Employee it not only shows data for that employee but it also shows data for All Subcontractors. (see below)

Is there a way to have "None Selected" as the default option for a slicer? 

[EdwardMoradian]

What you can do with the new feature of Field Parameters (check in Preview features):

1. Create a Column Called None with all blank values of ""
2. Create a Field Parameter to select None field as well as the other fields you want (this lets you combine the fields together into 1 Slicer).
3. Make Field Parameter into a Slicer.
4. Now you will have a Slicer with None option that will give a blank result.  Select for this as the default to not show any results.  Save the dashboard in this state to keep the selection this way.  You can select the other fields to populate data.

                 

[v-kkf-msft]

Hi @DSwezey ,

This feature is currently not supported, please submit your ideas.

https://ideas.powerbi.com/ideas/ 

A workaround is to use the measure to change its default value to blank. You need to add the measure as a visual-level filter for visuals. And, it will still return null when you select "Select all".

SelectedValue = 
IF (
    COUNTROWS ( ALLSELECTED ( Subcontractors[Subcontractors] ) )
        = COUNTROWS ( ALL ( Subcontractors[Subcontractors] ) ),
    BLANK (),
    1
)

    

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