Preselected slicer help needed

[Kopek]

Hello!

I am having an issue with using a preselcted slicer vizualization.
I was able to figure it out how to use with dates, but i want to use it with a text entries right now.

Preselected Slicer (microsoft.com)

I am having different data labesl for different clients:

Data Label	Client	Default ?	Label id
Label 1	111	Yes	1
Label 2	111	No	2
Label 3	111	No	3
Label 2	222	Yes	2
Label 3	222	No	3
Label 1	333	Yes	1
Label 2	333	No	2
Label 3	333	No	3
Label 4	333	No	4
Label 1	444	Yes	1
Label 2	444	No	2
Label 3	444	No	3
Label 4	444	No	4
Label 1	555	No	1
Label 2	555	Yes	2
Label 3	555	No	3

I have also created true / false table for Dirty Status: (made sure format = true/false)

Column1

True

False

This is my fields set up for the preselcted slicer:

Can somebody help me in creating a proper measure for Pre Selection filed, so that labels makred as "Yes" in Default? column are picked up by slicer from default ?

Thanks in advance!

ps report is filtered by client id from report lvl filter, so there is always only data for one client visible.

[Anonymous]

Hi @Kopek 

Please try this:

I create a measure:

MEASURE =
VAR _selectedDefault =
    SELECTEDVALUE ( 'Table'[Default ? ] )
RETURN
    _selectedDefault = "Yes"

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kopek]

Hi, thanks for thath, but to the slicer i want to take data labels, not yes, no.
Yes, no column is only an idicator showing which label to be selected from default