Slicers - force '(blank)' option and select from others

[Anonymous]

Hi,

I have a slicer with options: '(Blank)', A, B, ...

The way the data/measures are set up means I need '(Blank)' (ie the rows in the data where this slicer field is missing) to always be selected, along with any of the other options the user chooses. 

Is there a way to force the (Blank) option to be ticked in the slicer? So the user will always have (Blank) + whichever their choices are from the remaining options?

Thanks for any help

[ParkingLotView]

This is very helpful. Thank you

I noticed that this works for single selections only. Is there a way I could have the blanks permanently included even if I select multiple items. I'd really appreciate your help on this.

[jaideepnema]

Hi @Anonymous ,
i really doubt if you can force select a particular field in a slicer and change the other one.

As a workaround I would suggest to add two slicer lets say: First and Second, first  shouldnt interact with second one but the opposite can happen. You can select Blank from the first slicer and even hide it using bookmarks if required.

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[Anonymous]

thanks for your reply!

If I put in a second slicer with the same field and then select an option, the first filter no longer has the entire option list (just the one I selected shows) - as the data has been filtered already

[jaideepnema · Accepted solution]

Hi @Anonymous ,
Not sure how to achieve this when more than one value is selected in the slicer apart from Blank. 

But in case you want to use single selection where a user can select only value along with blank always available/filtered/selected. You can create one more disjoined table of the field used in the slicer. Add a measure like below and apply the filter 1 as a visual level filter.

Filter = IF(or(ISBLANK(SELECTEDVALUE(Data[Class])),(SELECTEDVALUE(Class[Class])=SELECTEDVALUE(Data[Class]))),1,0)

Here the data table is the fact table which contains all your data and class table is the dimension table not having a relationship with the data(fact) table.

Check if the attached pbix helps to answer your query .

Happy to help !!

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/