Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Two (slider) slicers synced on same page

Hi,     I want my two slicers to be dynamically synced when on the same page.  They are two columns of the same table.   The problem is that once the first one is selected, the 'date...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Anonymous ,

     

    Try to select WeekNum slicer, then change the interactive mode to "Filter".

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-kkf-msft , thanks for the answer, it seams to work ... just not always.

Let say the user just picked a date in the date slicer, like this:

then your solution doesn't work anymore and selecting a week in the other slicer doesn't override the selected date's values.
I want the date field to always display the right filtered dates ...

Do your have a solution for this ?

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Changing the value of the WeekNum slicer (e.g. 5) will not change the range of the Date slicer, but we can see that it will only display the date that the week number is 5.

 

 

If you want the Date slicer to display only the date with 5 week number, you can try to change the slicer type from Between to List.

 

 

Best Regards,
Winniz

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-kkf-msft  Isn't there a way to force update the slider ? i want to keep both as they are...

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      v-kkf-msft Sorry for the retag, but do you have an answer to my last question ?

      I still need my two slicers as they are, one segment and one list.

      • v-kkf-msft's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        Sorry for the long time no response. I have no other way to achieve your desired output in the slicer other than changing the type of date slicer to List.

         

        If you can accept a parameter, you can try the following steps:

         

        • Add the WeekNum column as a new query in Power Query.

                        

        • Remove duplicates.

                       

        • Create query parameters

               

        • Filter the WeekNum column

              

        • When you change the parameter value, once you move the slicer, the slicer's range will be updated.

               

         

        Best Regards,
        Winniz