Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to always have value in a slicer power bi desktop

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"

enter image description here

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.

enter image description here

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")
like image 443
Serdia Avatar asked Mar 07 '23 02:03

Serdia


1 Answers

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.

like image 75
Alexis Olson Avatar answered Mar 20 '23 17:03

Alexis Olson