Sharepoint list date and time in power bi table visuals

[bzeeblitz]

At sharepoint list I have order Date whichnis Date and time column databtype

And basically I'm using table visuals in power bi and in my visuals I see as below but I do not want time in the power bi table visuals

So how to trim the time from powerbi

Order Date

3/17/2025 7am

3/16/2025 8am

[Anonymous]

Hi @bzeeblitz ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

HI @bzeeblitz,

You can change the field to date type to remove the time part values. If you do not want to change the original value and just want to change its display format. you can try to use field formatting string.

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

if the column is not used in a join you can format the values as Date only.  If it is then you can create a calculated column with DATEVALUE().