Forum Discussion
Helper IChange the way a table visualization displays date
Hello power-bi-noob ,
format the date column with the datecolumn tools tab to short date.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Super UserHello,
If you want you could dublicate the column and format it mm/dd/yyyy and use it in the matrix or split the main column into date alone and time alone.
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Helper II duplicated the column, and changed the column format to date, and it looks fine in the table (mm/dd/yyyy instead of mm/dd/yyyyy hh:mm:ss).
Now, for some absurd reason, it shows the name of the day in the table visualization, which clearly isn't displayed in the table.
All I want it to show is 12/30/2022. It doesn't seem like it should be this hard.
- Idrissshatila
Hello power-bi-noob ,
format the date column with the datecolumn tools tab to short date.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- power-bi-noob
Perfect! I knew it couldn't be that hard, the interface on this program just seems to be very complex. Thanks!
Idris, do you know a way of updating the date format & data type for all date columns across all tables?
If you select the date dropdown under the visualization section, there is an option for "date" and "date heirarchy" which is the default. Change it to "date" and it will display whatever date format you have on the table.
