Forum Discussion
Helper IIChange multiple slicer fields based on one slicer
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.
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