How to change date format in Matrix visualization (Value column)

[shubhamamilkant]

I am trying to change date format into (MM/DD/YY) from matrix visualization table when date is in value column.  below picture shows current format.

Thanks,

Shubham Amilkanthwar

[parry2k]

@shubhamamilkant select the column you want to format and on column tools in the menu, change the date format the way you want it

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[shubhamamilkant]

@parry2k  In query editor it is already in Date format. but when i select Matrix visualization and put date into the value column, and it does not shows same format.

Thanks,

Shubham

[parry2k · Accepted solution]

@shubhamamilkant in the query editor, you are telling the type of the column not how it should display or in other words, the format of the table, as suggested once data is loaded, select the column and change the format, see screenshot below

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Syndicate_Admin]

Thank you! Solved

[shubhamamilkant]

@parry2k you are the best. Thank you so much, I spent half an hour on this. ❤️