Incorrect Date format in Text box

[nj17]

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

[v-easonf-msft]

Hi， @nj17 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @nj17 

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

[nj17]

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?

[v-easonf-msft]

HI, @nj17 

I can't see any issue on my side.Please check my sample file for more details.

_Title test = FORMAT(LASTDATE('Table'[Date]),"MM/DD/YYYY")

_Title =
VAR weenkenddate = [_Title test]
RETURN
    "Dashboard" & "as of(" & weenkenddate & ")"

Can you share your sample file for testing?

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

HI @nj17 

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

[nj17]

@PhilipTreacy @mahoneypat 

kindly see below image where date formate changed automatically 

[PhilipTreacy]

Hi @nj17 

I'm curious, in your measure FORMAT is using // as separators so that's what you should get.

We can't see the rest of your code, what's after the RETURN?

Regards

Phil

[nj17]

Hi @PhilipTreacy 

see below image I am using this measure in title of a textbox

[mahoneypat]

You can try "MM/dd/yyyy" instead, or you can not use FORMAT, highlight the measure and select the desired format in the ribbon.

Pat

[nj17]

Hi @mahoneypat 

I tried "MM/dd/yyyy" but it didnt help.I can not select formate of this measure as date as it returns text and date.