Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
power-bi-noob
Helper I
Helper I

Change the way a table visualization displays date

I have a table visualization that includes a date, which currently displays as mm/dd/yyyy hh:mm:ss. I would only like it to display as mm/dd/yyyy for this particular visualization. I do not want to change the data in the source table as the timestamp portion is useful in other contexts. How can this be done?

1 ACCEPTED SOLUTION

Hello @power-bi-noob ,

 

format the date column with the datecolumn tools tab to short date.

Idrissshatila_0-1673016710634.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

13 REPLIES 13
grandtotal
Resolver III
Resolver III

Or depending on your model you can use a measure:

 

FORMAT(<value>, <format_string>[, <locale_name>])

 

https://learn.microsoft.com/en-us/dax/format-function-dax#datetime-with-optional-locale_name

 

 

mcgeeks
Helper I
Helper I

First, you can look at whichever app is used for the visualization and see if the formatting you want is available within that app.

 

PowerBI doesn't modify original content.  It reads it in with powerquery and lets you adjust it how you want via transform within PowerBI only.   In transform you can either adjust the original columns (which doesn't adjust the actual data where you're getting it from) OR if you want to play it safe you could just duplicate the column within the transform and format it the way you want in the new column, then use that differently formatted column for your visualization.  

I am looking to change this field's appearance in this visualization only, I don't want to change it in the model. If I want to make the value the color blue, I can, but if I just want to see the date without the time, that doesn't seem to be an option. You can easily do this in Excel (change the way the date displays without changing the underlying data). It's puzzling that you can't do that in Power BI.

In that case, I have added columns via splitting the original into 2 new columns (leaving the combined original).  Then using whichever column you want/need... in your case it sounds like the date without time column.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos

mcgeeks_0-1672868293356.png

 

 

Idrissshatila
Super User
Super User

Hello,

 

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👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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).

powerbinoob_1-1673016224065.png

Now, for some absurd reason, it shows the name of the day in the table visualization, which clearly isn't displayed in the table.

powerbinoob_0-1673016042305.png

 

All I want it to show is 12/30/2022. It doesn't seem like it should be this hard.

Hello @power-bi-noob ,

 

format the date column with the datecolumn tools tab to short date.

Idrissshatila_0-1673016710634.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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.

Idris, do you know a way of updating the date format & data type for all date columns across all tables? 

Perfect! I knew it couldn't be that hard, the interface on this program just seems to be very complex. Thanks!

If I duplicate the column, what happens the next time I import the data from the original source which would not include this data?

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 👍

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.