Forum Discussion

Cezar's avatar
Cezar
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • HashamNiaz's avatar
    HashamNiaz
    4 years ago

    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

HashamNiaz's avatar
HashamNiaz
Solution Sage
4 years ago

Hi Cezar !

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

 

Regards,

Hasham

Cezar's avatar
Cezar
Frequent Visitor
4 years ago

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's avatar
    HashamNiaz
    Solution Sage
    4 years ago

    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