Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DSwezey
Helper III
Helper III

Default Slicer to none selected

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

DSwezey_0-1653488087416.png

 

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)

DSwezey_1-1653488235032.png

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

2 REPLIES 2
EdwardMoradian
New Member

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.

EdwardMoradian_0-1666389079283.png                 

 

EdwardMoradian_2-1666389130259.png

 

v-kkf-msft
Community Support
Community Support

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
)

vkkfmsft_1-1653880470860.png    vkkfmsft_0-1653880445146.png


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

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors