Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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
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
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 !
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
59 | |
30 | |
24 | |
23 | |
21 |
User | Count |
---|---|
57 | |
37 | |
24 | |
23 | |
20 |