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. Thats what I am trying to prevent.
I created measure "DateTypeSelected" using SELECTEDVALUE
but I dont think you can use measure in a slicer.
DateTypeSelected = SELECTEDVALUE('Date Type Slicer'[Date Type],"Effective Date")
Unfortunately, I don't think there's a solution to this currently.
You can see that it's a popular request on the Power BI Ideas forum, so I'd recommend voting and leaving a comment there.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With