Forum Discussion
Preselected slicer help needed
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.
2 Replies
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.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
