Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Cezar
Frequent Visitor

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). 

 

Cezar_0-1640086687631.png

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.

 

Cezar_1-1640086770584.png

 

Ty for your time.

 

Regards

Cezar

 

 

1 ACCEPTED SOLUTION

Hi @Cezar !

 

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

 

HashamNiaz_0-1640100181710.png

 

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

 

Regards,

Hasham

View solution in original post

5 REPLIES 5
v-luwang-msft
Community Support
Community Support

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
Community Support
Community Support

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")

vluwangmsft_0-1640573666991.pngvluwangmsft_1-1640573676372.png

 

 

Best Regards

Lucien

 

HashamNiaz
Solution Sage
Solution Sage

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;

 

HashamNiaz_0-1640100181710.png

 

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

 

Regards,

Hasham

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors