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")