How to always have value in a slicer power bi desktop

Question

I have a slicer with two values: "Accounting Date" and "Effective Date". How to always keep one value selected, NOT both selected or NOT both unselected.

On a screenshot below selected "Effective Date"

The slicer has "Single select" on, but I still able to select both values.

And now both values unselected. That's what I am trying to prevent.

I created to measure "DateTypeSelected" using  SELECTEDVALUE but I dont think you can use measure in a slicer.

DateTypeSelected = SELECTEDVALUE('Date Type Slicer'[Date Type],"Effective Date")

Answer 1

• Currently there is no solution to this but to mitigate the problem, you can safeguard your measures from showing incorrect results, or display an error message if the user makes an invalid selection.

• Create a measure like this, which will return TRUE if only a single value in the slicer is selected:

IsValidDateType = COUNTROWS(VALUES('Date Type Slicer'[Date Type])) = 1

• And then you can adjust your measure like this:

MySum = IF([IsValidDateType], SUM(fact[value]), BLANK())

• And you could create an error message measure like this, which could be added to a card to inform the user of invalid selection:

DateTypeErrorMsg = IF([IsValidDateType], " ", "Please select one, and only one, value for Date Selection.")