Forum Discussion
Visualization automatically adds time to date column
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
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
5 Replies
Hi Cezar !
Please ensure data type of column is set as [Date] & formatting can be done at visual level.Regards,
Hasham
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
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
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
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
