Forum Discussion

cheryl0316's avatar
cheryl0316
Icon for Helper II rankHelper II
2 years ago
Solved

Change 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 ######## ##...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

     

     

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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.