how to covert date format when open published the report with other user

[krishna_murthy]

Hi Team,

i have a new requirement 

i have created sales report in that added the slicer as a date format in showing is 12/11/2025(DD/MM/YYYY)   but when the user open the sales report organizational workspace the date format is showing  11/12/2025(MM/DD/YYYY)

Is there any way avaialble what ever we create same format can view.

thanks

[v-kpoloju-msft]

Hi @krishna_murthy,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @Ahmed-Elfeel, @Zanqueta, @DataNinja777,  for his inputs on this thread.

Has your issue been resolved? If the response provided by the community member @Ahmed-Elfeel, @Zanqueta, @DataNinja777, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @krishna_murthy,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[Ahmed-Elfeel · Accepted solution]

Hi @krishna_murthy,

Just create a formatted date column that sorts correctly:

• In Power Query Create a custom column:

Date.ToText([YourDateColumn], "dd/MM/yyyy")

• In Data View:

  • Select the new formatted date column

  • Go to Column Tools → Sort by Column → Choose your original date column

• In Report:

  • Use this new formatted date column in your slicer

 It wll result that all users will see 12/11/2025 (DD/MM/YYYY) regardless of their system settings and the slicer will sort chronologically

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

[Zanqueta]

Hi @krishna_murthy,

Alternatively, you can format the date as text in Power Query or duplicate and format your new column in order to don't remove relationships and then use it in your slicer control:

Text.Format("#{0:dd/MM/yyyy}", [Date])

Limitations:

• These approaches convert the date to text, which means you lose native date functionalities such as sorting chronologically or using relative date filters.
• If you need to retain date logic (e.g., filtering by month or year), you may need to keep both the original date field and the formatted text version.

✅ If this response resolved your issue, please mark it as correct to assist other members of the community.

[krishna_murthy]

@DataNinja777 --- Iam not looking for date format

iam looking for when i have added the date format 12/11/2025(DD/MM/YYYY) and published into workspace , same report client open their system then date format showing is 11/12/2025(MM/DD/YYYY).

i know the issue and soutions also this is occures google chrome date format issue ...usually by default in googe show format is ---- english (United Status)  then we can change setting -----> lanugauge ---> English (United Kingdom).. then it will work as per our requirement. 

But 

Every client/user will not change the google format right then we have find out solutions ??? 

like when the user open the report then automatically date format will change and shows as DD/MM/YYYY .

Team, pleaes check and do the needful.  

[DataNinja777]

Hi Krishna,

The issue you are noting is the standard behavior due to locale setting.  Each users have their locale setting, and the date will be displayed according to their setting. In order to resolve your pain point, you can use a calculated column like below to fix the date format and use that in the slicer.  

Date Slicer (DD-MM-YYYY) = FORMAT( [YourDateColumnName], "dd/MM/yyyy" )

Resultant slicer will have exactly that date format regardless of the setting in locale.  In order to ensure that the slicer is sorted in the date order, you can sort by the another date column in your calendar table. 

Best regards,