Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am currently using a quick measure and it has pulled through the data i need but it has changed the format of the date to MM/DD/YYYY whereas i need it to be DD/MM/YYYY. Can anyone help?
I have searched through the possible solutions and i cant seem to get anything to work. I have also looked in these forums and any codes provided so far have caused the measure to break.
Solved! Go to Solution.
Try wrapping 'Actions'[StartDate] in lines 15 and 24 with FORMAT using the appropriate format string:
FORMAT ( 'Actions'[StartDate], "dd/mm/yyyy" )
Apologies i think i was flustered and misread your first answer, this has worked now! Thank you 🙂
pls try
new measure = FORMAT([List of StartDate values], "dd/MM/YYYY")
Unfortunately this appears to have kept the date the same, thank you for your support though
Try wrapping 'Actions'[StartDate] in lines 15 and 24 with FORMAT using the appropriate format string:
FORMAT ( 'Actions'[StartDate], "dd/mm/yyyy" )
This appears to have broken the measure and isnt accepting the dd/mm/yyyy on there
Thank you for your help though!
You're missing a comma at the end of that line. You've also changed line 27. I don't recommend formatting the sorting arguments in lines 17 and 27, just lines 15 and 24.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
55 | |
38 | |
31 |
User | Count |
---|---|
71 | |
64 | |
64 | |
49 | |
45 |