PowerBI - Date Format in Visual

[tietvinhphuc]

Hi,

I used long text format for Date data - it quite long in Visual e.g. Monday, Jan 1, 2024

How do I change to shorter form e.g. Mon, 01-Jan-24? I need date of week (Mon - Sun). 

Thanks,

Phuc

[Ritaf1983 · Accepted solution]

Hi @tietvinhphuc 

ddd,mm-dd-yy

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[vicky_]

You will need to use a DAX measure:

Custom Date Format = FORMAT(SELECTEDVALUE(YourTableName[Date]), "ddd, dd-mmm-yy")

[tietvinhphuc]

Hi,

Thanks. I tried and the column stored data as text, and I could not properly sort by date. And if I changed data type to date, then ERROR. 

[ryan_mayu]

you can change the format under the column tools tab. 

[Ritaf1983 · Accepted solution]

Hi @tietvinhphuc 

ddd,mm-dd-yy

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[tietvinhphuc]

Hi, I don't found anyway I can create a custom format as in the dropbox. See below

[Ritaf1983 · Accepted solution]

Hi @tietvinhphuc 

Just click there and type instead of selecting from the list.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[tietvinhphuc]

Hi,

Thanks, It works just as expected. It is much simpler than I thought 🙂

[Ritaf1983]

Happy to help💕