Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Default Slicer to none selected

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? 

Need Help

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    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.

     

     

  • EdwardMoradian's avatar
    EdwardMoradian
    New Member
    3 years ago

    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.