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.

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

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks for the answer, that is not what i want though.

        Thank you for your time and help, i'm trying to find other ways to show my data that doesn't involve this problem but i think it should be a feature ...