Forum Discussion
PowerBI - Date Format in Visual
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
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.
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.
8 Replies
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.
Hi, I don't found anyway I can create a custom format as in the dropbox. See below
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.
you can change the format under the column tools tab.
You will need to use a DAX measure:
Custom Date Format = FORMAT(SELECTEDVALUE(YourTableName[Date]), "ddd, dd-mmm-yy")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.
