Forum Discussion

gromero17's avatar
gromero17
Frequent Visitor
8 years ago

Date Filter Adds One Day to Upper Bound

I'm having an issue with a date filter in my published report. The error does not occur in the desktop version. 

 

Summary of the issue 

I have several tabs on the report. I set my desired date range on one tab of the report. When I switch to the any other tab, the visual has added 1 day to the upper bound. The data itself remains locked to the original date filter, but the visual is showing something difference. This repeats itself every time I change anything to the lower bound and switch tabs. All the date slicers on each tab are synced. 

 

This is causing a ton of confusion amongst my end users, so any help is really appreciated!

 

Example

I set the date range on one tab shown below. 

  

I switch over to any other tab, and is shows this. 

   

 

Note the upper bound is one day greater than the original filter I had set. 

6 Replies

  • luxpbi's avatar
    luxpbi
    Icon for Helper V rankHelper V
    8 years ago

    Is the relationship of your date calendar set in both directions?

     

    Please consider to upload a dummy pbix file that can reproduce the error.

    • gromero17's avatar
      gromero17
      Frequent Visitor
      8 years ago

      Luxpbi, 

       

      I tested the bi-directional and mono-diectional relationship and the issue persisted. I've recreated the error using this pbix. The error only happens once I publish the pbix to the service. 

       

      Steps to reproduce error: 

      1) publish pbix to workspace.

      2) Set lower bound date to 1/1/2016 on Page 1

      3) Set upper bound date to 12/1/2017 on Page 1

      4) Switched to Page 2 and the upper bound now reads 12/2/2017 even though the slicers are synced.

       

      *Note you can enter in any date and the issue will come up. 

       

      Please let me know if you cannot access the file. It's the first time I share a file. 

       

      https://www.dropbox.com/s/qhsd49enpa6kxtc/PBI%20Test.pbix?dl=0

       

       

      • luxpbi's avatar
        luxpbi
        Icon for Helper V rankHelper V
        8 years ago

        gromero17,

         

        Try this: 

        • Disable the actual relationship between your calendar table and your data table. 
        • Create a new table with the following DAX code: 
        CALENDAR =
CALENDAR (
    MINX ( 'Sample'; 'Sample'[Date] );
    MAXX ( 'Sample'; 'Sample'[Date] )
)
        • Create a new relathionship one to may between your new calendar table and your data table. 

        For me it works.