Button to unselect Blank from multi select list

[Korn_Tris]

As you know when you have the multiselect list - the list would also include blank in them. However this blank thing make some error to my formula and thus i need to remove it out.

But to remove it , i don’t want to use the selection pick . i want to use a button to modify it.

I have tryting to figure out a button to modify multiselect list where as the BLANK selection is to be remove from the list.

Anyone could help?

[Jean_Pierre_Traets]

This post/solution should give you some inspiration @Korn_Tris

Filter a Table with True False or All Values

I have solved the problem: inside the filtering options of the SwitchIf if you want to see all results you need to use the OR for the “All status” set the syntax like that: SwitchIf([Filter Table].[Filter By Completion]="All Status",thisRow.[Completed?] OR Not(thisRow.[Completed?]),[Filter Table].[Filter By Completion]="Completed",thisRow.[Completed?],[Filter Table].[Filter By Completion]="Not Completed",Not(thisRow.[Completed?])) You Can Check the option in this doc

[Tomislav_Mamic]

You can set Value for new rows that will automatically set a certain value when a new colum is selected. This way you will avoid setting empty value by mistake. You will still be able to remove any value from the cell. You can then also create a button that will filter all rows with empty value, and modify them to have some other value.
Besides that, you can modify your formula to behave differently if the value is blank.