Forum Discussion

MW630's avatar
MW630
Frequent Visitor
8 years ago

Date slicers syncing incorrectly across tabs

Hello,

 

I have a report with a date slicer that is synced between the 3 tabs. When I preview it in PBI desktop everything works as expected. However, when I publish the report and select a date on the first tab through a browser, it adds a day to the date slicer on the 2nd and 3rd tab of the report.

 

For example, you select 6/1/2018 on the first tab of the report. The date slicers on the 2nd and 3rd tabs will sync to 6/2/2018.  This is causing a big issue for our users as we are trying to get our company onboard with adopting PowerBI reports.

 

I have tried using different web browsers, updating PBI desktop, removing and re-adding the slicers, removing and re-adding the sync, and completely recreating the report. But I get the same result.

 

Please advise how to resolve.

 

Thank You,

Mike 

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    MW630, Share your sample data, and I will try to create something based on that, if possible upload your Power BI Desktop file to Online Storage snd Share the same so that I can have a look.

     

    Thanks,

    Jayant

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Hi MW630,

     

    Could you share a mockup with some dummy data to clarify more explicitly about the issue.

     

    Regards,

    Jimmy Tao

    • MW630's avatar
      MW630
      Frequent Visitor

      Hello v-yuta-msft,

       

      Thank you for getting back to me. The date slicers are synced across the two tabs of the reports.  The "From" date seems to sync correctly, it's just the "To" date that adds a day. 

       

      When viewing the report in Power BI desktop, the date sync works correctly. When I publish it to PowerBI, it adds one day on the second tab. 

       

      Here is Tab 1:

       

      Here is Tab 2:

       

      This was generated using the following data.  It doesn't matter what date I pick, it will always add one day.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi MW630,

         

        I replicated your Power BI report and it seems to be working fine as expected, please see the screen shot below.

         

        1. Data

         

        Sample Data

         

        2. Page 1 or Tab 1 

        Page1

         

        3. Page 2 or Tab 2

        Page2

        If you can share your Power BI file, then we could be able to locate the exact issue.

         

        Thanks,

        Jayant

         

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion

    Does this occur with every date you try?