Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Is there a way to change the text input boxes for report parameters to accept dates in UK format. They report invalid date when attempting to use e.g. 20/01/2020 and instead want to force it to use MM/dd/yyyy (US Format).
I've double checked all region / locale and browser (Chrome) language settings inclduing the PBIX global and file settings to ensure they're all British English and United Kingdom.
Hi @SQLSi ,
I'm afraid it's set up to be unchangeable. However, you can change the parameters to text instead of date.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jay,
The problem is that when you change the parameter from datetime to text, the date-picker disappears. Many users want to choose between date-picker and manual input. When the parameter-format is datetime, the manual input 01-10-2023 (oktober 1st) changes automatically to 10-01-2023 (januari 10th). Outside the US the world uses DD-MM-YYYY instead of MM-DD-YYYY. Please make this regional-dependent, Microsoft-team!
hi Jay,
How do we get microsoft to fix this for the 90% of the world that isnt the U.S.
Im in Australia and have the same problem and it annoys my users no end
Mickeal
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
52 | |
35 | |
32 | |
30 | |
25 |