Forum Discussion
Helper IIChange multiple slicer fields based on one slicer
| 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?
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.
3 Replies
- lbendlin
Super User
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.
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.
cheryl0316Hi 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
