Format Datetime as Date in Tables or Matrices

[dkernen]

Hello.  I have a date in my dimension table that I want to show on a table.  It is a datetime, and I do want it to format as datetime MOST of the time.  Except for one table.  I can use the FORMAT pane to change the FIELD FORMATTING of other numeric fields (to change the display units or the number of decimals shown).  But what I need is a way to show only the date on this table.  Where or how can I do that?  Of course this is extremely simple in Excel, but I cannot find where I can display the date of my datetime.  Any ideas?  Many thanks in advance! 

@dateformats @datetimeformats

[v-henryk-mstf]

Hi @dkernen ,

According to your requirements, there is no need to modify it in the Format pane. You can create a measure to customize the display format of the date in the dimension table, refer to the following:

If it still does not solve your problem, you can try to provide the expected date type you want to display in Excel or further describe your needs. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dkernen]

Hi Henry.  This is not working for me.  When I try to write a measure using format, it will not allow me to enter a column in the first parameter of the FORMAT function as it is looking for a value only.  

I wrote up an Idea for this simple functionality.  https://ideas.powerbi.com/ideas/idea/?ideaid=6d51d4a7-d967-eb11-8fed-281878deecac

[Anonymous]

HI @dkernen 

Create the below measure on the datetime column and use it in One table instead, to show only date.

Only_date = FORMAT('table'[datetime],"MM-DD-YYYY")  //Choose your desired date format here.

[PhilipTreacy]

Hi @dkernen 

I think you'll have to create another column in your model that just holds the date, and display that.

Regards

Phil