Forum Discussion
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
- AnonymousNot 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
Community Support
Hi MW630,
Could you share a mockup with some dummy data to clarify more explicitly about the issue.
Regards,
Jimmy Tao
- MW630Frequent 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.
- AnonymousNot 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
Community Champion
Does this occur with every date you try?