Change multiple slicer fields based on one slicer

[cheryl0316]

Name	File Creation Date	Last Visit Date	Over2Years_File Creation Date	Over2Years_Last Visit Date
Mary	########	########	Yes	No
Tom	########	########	Yes	Yes
Judy	########	########	No	No
Amy	########	########	No	No

I want to create a field switch.  Something like this

If I click Last Visit Date, the date slicer will show Last Visit Date and the Over2Years slicer will show Over2Years_Last Visit Date.

Is it possible to change multiple slicer fields based on one field switch?

Any advice is appreciated. Thanks!

https://drive.google.com/file/d/13nALR8F99aM1G2boH24UnwuQTqDbOazg/view?usp=sharing

Btw how can I upload PowerBI file directly here?

[v-jiewu-msft · Accepted solution]

Hi @cheryl0316 ,

Please try the following methods and check if they can solve your problem:

1.Create the two simple tables.

2.Create the new measure to filter.

Field Selected = IF ( SELECTEDVALUE ( 'FieldTable'[Field Switch] ) = "Last Visit Date", 1,0 )

3.Drag the measure into the date slicer and Over 2 years slicer. Select the show items is 1.

4.Select the Last Visit Date in the Field slicer. The result is shown below.

For the upload file question, only upload files directly if you are a super user or a support member.

Solved: How to upload PBI in Community - Microsoft Fabric Community

Best Regards,

Wisdom Wu

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

[cheryl0316]

Hi Wisdom,

Thanks for your reply. I have applied your method on my dashboard. Not sure if I did something wrong but the date slicer doesn't seem to work. Could you please have a look? Thank you.

https://drive.google.com/file/d/13nALR8F99aM1G2boH24UnwuQTqDbOazg/view?usp=sharing

[lbendlin]

You cannot set slicer values programmatically.  The slicer options you see are dictated by the data model and the current filter context.

This can lead to confusion when a previously selected choice is no longer part of the filter context.  This can lead to outright data leakage when RLS is involved. That's why you should never mix RLS with default slicer choices.

You can only upload files directly if you are a super user or a support member.