Visualization automatically adds time to date column

[Cezar]

Hi everyone

I have a question about power Bi web version. When I add a date column to the report it automatically adds a time next to the date to several instances. I can be a list, card, etc. it will still add the time (screenshot below). 

Opening it in the desktop version it works fine with no time input. The data set has no times added to it either so I am rather confused why does it do this.

Ty for your time.

Regards

Cezar

[v-luwang-msft]

HI @Cezar ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Cezar ,

Can you share your pbix files, I am testing publish in my environment, remember, remove confidential data.
Also, I have no problem publishing my own data in my local environment.

Table = CALENDAR("2021,12,11","2021,12,24")

Best Regards

Lucien

[HashamNiaz]

Hi @Cezar !

Please ensure data type of column is set as [Date] & formatting can be done at visual level.

Regards,

Hasham

[Cezar]

Hi @HashamNiaz 

The data within the excel is set as Short Date throughout the column. Where would I find the option to format it at visual level ? Field formating doesn't seem to have an option for that.

Regards

Cezar

[HashamNiaz · Accepted solution]

Hi @Cezar !

First you need to choose data type of your column in Power BI using below;

Clik on the Column, using Column Tools -> choose Data Type & Format as mentioned in teh Image.

Regards,

Hasham