Forum Discussion

JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive Resident
9 years ago

Discrepancies between Desktop and PowerBI.com

Hi all.

 

I've set up a simple matrix within Power BI desktop model using DirectQuery and added a date filter and it works perfectly (see below).

Power BI Desktop

This returns just the dates as expected. However, when publishing the report, the date filter on PowerBI online doesn't match up at all (See below)

Power BI Online

If anyone has any thoughts i'd love to hear a potential fix!

 

Thanks in advance for your help. 

Need Help

3 Replies

  • JoHo_BI's avatar
    JoHo_BI
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    Still need help if possible.

     

    I've also checked in multiple browsers and that didn't help. As you can see in the screenshots though the date's still revert. Is there a chance this would be causing the issue?

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      JoHo_BI

       

      I haven't reproduced your issue. The slicer works properly on Power BI Service.

       

       

       

      I noticed that your date formats changes on Power BI Service. You may change your system date format

      into your current region date format, recreate your slicer and try again.

       

      Regards,

      • robhardy's avatar
        robhardy
        Regular Visitor
        9 years ago

        Hi v-sihou-msft,

         

        I believe I am experiencing the same issue. I am in the UK (standard date format dd/mm/yyyy). Dates are displaying correctly in Power BI Desktop, but when I publish to powerbi.com, they are displaying in US format (m/d/yyyy):

         

         

        The dates JoHo_BI used are ambigous, but the dates you were testing with are clearly in US format in both shots (4/13/2013), so I'd suggest the issue only arises when using a non-US date format in the Desktop app.

         

        We have a similar issue with SharePoint online, but can change the regional settings when each site is created. I have tried to find a similar configuration option in the Power BI web interface, but been unable to.

         

        Yours,

        Rob.