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

10 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi PhilipTreacy 

       

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

       

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    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

    • 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

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hiļ¼Œ Anonymous 

    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.