topic Re: how to covert date format when open published the report with other user in DAX Commands and Tips

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

krishna_murthy — Wed, 12 Nov 2025 08:50:31 GMT

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

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

DataNinja777 — Wed, 12 Nov 2025 10:12:21 GMT

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,

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

krishna_murthy — Wed, 12 Nov 2025 11:48:00 GMT

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.

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

Zanqueta — Wed, 12 Nov 2025 12:26:43 GMT

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.

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

Ahmed-Elfeel — Thu, 13 Nov 2025 02:32:07 GMT

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.

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

v-kpoloju-msft — Sun, 16 Nov 2025 13:41:58 GMT

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.

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

v-kpoloju-msft — Wed, 19 Nov 2025 04:11:01 GMT

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.