Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to have the date format in DD-MM-YYYY. This format shows correctly both in desktop and service. But when an email subscription is sent the date format changes to MM-DD-YYYY and thats what the users see in the image which they receive by email.
Can someone please help with this issue? Irrespective of the region I would like the users to see date in DD-MM-YYYY in the email subscription image.
Regards
Rosh
Solved! Go to Solution.
Hi @Rosh89 ,
this is expected behavior:
The reason is this:
And refer the following article:
Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft Docs
Best Regards
Lucien
Hi @v-luwang-msft ,
Thanks for the detailed explanation Lucien. What you shared definitely works on table visuals. But the same does not work on date slicers.
You can see in the image from the subscription received the order of the date was changed to MM-DD-YYY which is what I want to resolve to DD-MM-YYYY.
Best Regards,
Roshan
Hi @Rosh89 ,
this is expected behavior:
The reason is this:
And refer the following article:
Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft Docs
Best Regards
Lucien
Please kindly vote for that change idea to support dd/mm/yyyy in subscription email preview:
Hi @v-luwang-msft ,
Understood now. Powerbi service accepts US english only and it can only be corrected when I change to another language which follows DD-MM-YYY format.
Many thanks!
Best Regards
Rosh
Hi @Rosh89 ,
How did you get "DD-MM-YYYY"?You could try like me the below:
visual:
After publish:
Then subscription:
language setting:
You could test on the pbix file I shared.
Best Regards
Lucien
Hi,
you can make the change in your locale settings.
Below link might help :
https://www.mssqltips.com/sqlservertip/6834/power-bi-service-date-formats/
Please like my answer in case it helped you out!
Have a great day!
Hi,
I tried everything in the link. Changed language settings to english uk in chrome and powerbi service (default browser language) It still doesn't work. Somehow the date format changes to US format in the subscription image. Even tried changing language settings in outlook, still didnt work.
Hi @Rosh89
What I did first is change my browser to English UK and moved it to the top. Then I went to Power Service and change my language to default (not English).
This solved it for me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
18 | |
17 | |
16 | |
8 |