Forum Discussion
Incorrect Date format in Text box
Hi Anonymous
I presume you are actually using a Card visual, not a Text Box?
I can't reproduce the problem. But I don't know how you are creating the [_Title test] measure. Is it a date?
I also don't understand how the date in [_Title test] is 01/16/2021 yet in [_Title] the format is reversed to 2021-01-16 yet the code you show isn't altering [_Title test]. ARe we missing some piece of the puzzle here?
All I can think is that because you aren't doing an explicit conversion to text - assuming [_Title test] is a date - it is formating it in some default way.
So try doing an explicit conversion using FORMAT()
Also you can simplify your measure to this
_Title = "Dashboard " & "(as of " & FORMAT([_Title test], "mm-dd-yyyy" & ")")
Here's my PBIX if you want to check out my code to create the date and visual..
Regards
Phil
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?