Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
32 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
27 | |
18 | |
17 | |
17 | |
14 |