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👍
power-bi-noobIf I duplicate the column, what happens the next time I import the data from the original source which would not include this data?
Once you build the transformation it will work the same way every time you open it. So unless you're rebuilding your visualization every time you want to open/use it the transformation will remain the same unless and until you modify it.
- Idrissshatila
Hello,
When you refresh the data, your changes will stay and you don't have to remake them again.
If I answered your question please mark my post as a solution, Appreciate your Kudos 👍
- power-bi-noob
I 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!