Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sperry
Resolver I
Resolver I

date slider reverting to US dates when publishing

I have a desktop report that I publish to PowerBI online.

 

The data pulls from a SharePoint Online list which is set to English (New Zealand) in the regional settings.

 

I also control the date format in the Desktop model to be dd/MM/yyyy.

 

I have added a Date Slicer but if I choose the 'slider' option, which is what the business requires, then the date format reverts to US format when I publish - it shows correct in the Desktop instance.

 

If the Date Slicer is set to 'List' then it publishes in correct format!?!?

 

The PowerBI Online instance is set to Language > Default (browser language)

 

Any idea why or what I can do to correct?

1 ACCEPTED SOLUTION

Hi @sperry,

 

By my tests, you could change your Browser language to English (New Zealand). Then it will show the date format with dd/mm/yyyy.

 

date format.PNG

 

 

Best  Regards,

Cherry

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

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @sperry,

 

If I understand your sceanrio correctly that you set the date format with dd/MM/yyyy and create a date slicer in Power BI Desktop, but it show MM/dd/YYYY when you publish the report to Power BI Service?

 

Do you format the date with FORMAT function in Power BI desktop?

 

If the Date Slicer is set to 'List' then it publishes in correct format!?!?

 


It seems that it works correctly when you created the list date slicer, what kind of date slicer do you create when you have that issue?

 

In addition, what's the regional language do you set for your system?

 

Please describe your scenario in more details so that we could help further investigate on it?

 

Best  Regards,

Cherry

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

Kia ora Cherry

 

I control the date format by using the Modeling tab in the Report View in PowerBI Desktop.

 

I need to use the 'Between' option in the 'Slicer' visual. It is the to and from dates that are showing incorrectly. If I select the 'List' option the dates are showing correctly but a list is not useful for the users.

 

The Regional settings in both PowerBI desktop and SharePoint is English (New Zealand) and PowerBI Online is Default (browser language)

 

Please let me know if there is anything else you need..

 

Thanks

 

Steve

Hi @sperry,

 

By my tests, you could change your Browser language to English (New Zealand). Then it will show the date format with dd/mm/yyyy.

 

date format.PNG

 

 

Best  Regards,

Cherry

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.