cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
martinleo Frequent Visitor
Frequent Visitor

Date slicer interpreting dates as it pleases (UK and US)

Hi there,

Hope you can help me out with this one. I've got a report connected to a tabular cube. This report contains a date slicer which was intended to serve as a filter, but instead it's only causing pain and suffering. It works as expected on PBI desktop on development time, but once it's published, it works as it pleases: sometimes interprets dates in UK format and, when possible, it interprets them in US format.

Check out these examples. On the top the report, and on the bottom a query to the underlying cube.

1st example: 13th of april. Everything looks fine, the data in the report matches that in the cube.

1.png

 

2nd example: I go back one day to the 12th of April. Now the report tells me there is no data for this date. But the underlying cube proves it wrong.

2.png

 

That's strange... now what a coincidence 12 is also a month, unlike 13. Let's go to December and see what's going on there:

3rd example: Going forward to the 4th of December displays data from the 12th of April as per the previous image query against the cube.

3.png

 

In short, despite having everything set up to display dates in dd/mm/yyyy format (Windows regional settings, PowerBI desktop regional settings and Chrome/Firefox language settings with PBI web language set as default) PowerBI still interprets the dates in US format. Sometimes. Because for dates not compatible with US format, it displays everything correctly.

 

Any help or hint will be appreciated.

Regards,

Martin.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Date slicer interpreting dates as it pleases (UK and US)

Hi @martinleo ,

 

Please change your date in Power query to your local one as below.

 

chan.PNG

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Date slicer interpreting dates as it pleases (UK and US)

Hi @martinleo ,

 

Please change your date in Power query to your local one as below.

 

chan.PNG

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
martinleo Frequent Visitor
Frequent Visitor

Re: Date slicer interpreting dates as it pleases (UK and US)

Thanks Frank, that worked!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 178 members 2,291 guests
Please welcome our newest community members: