Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incorrect Date format in Text box

Hi All, I am creating a measure which returns date in textbox as below  but it returns date as 01-16-2021     how can I get date as 01/16/2021 amitchandak  Thanks
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi PhilipTreacy 

 

below is the screenshot of your pbix which you shared,here also i can see the same issue.

Or is Power BI using system date formate?

 

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

HI Anonymous 

There's no issue there, the dates are displayed as they should be.

The measure _Title test just displays a date without any applied formatting so it takes the default format which for you is mm/dd/yyyy

The measure _Title creates a string and formats _Title test to use - as separators so you are seeing mm-dd-yyyy   

To display the date with / as separator just change the measure _Title to this

_Title = "Dashboard " & "(as of " & FORMAT([_Title test], "mm/dd/yyyy" & ")")

Regards

Phil