Forum Discussion

JoHo_BI's avatar
JoHo_BI
Responsive 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). This returns just the dates as expected. How...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft 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.