Forum Discussion
Solved
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,...
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.
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.