Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

time show on visual not same type as data

Dear friends

 

i have time data but when i fill it as x axis on visual it show as date , what can i show it as time?

 

thanks in advance for any suggestions

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi, Anonymous 

     

    You can change the type of X axis to see if it helps.

    In the visualization pane > select format > click the X axis > change the type from continuous to categorical.

     

     

     

    If it does not work，I am wonder if you have changed the date type in the data view: From data/time to time.

     

     

    It may cause the same problem as yours，you can solve it by creating a new column to change the date type.

     

    New Column = TIME(HOUR([Date/Time]),MINUTE([Date/Time]),SECOND([Date/Time]))

     

     

    Change the date type from Date/time to time.

     

    Then you can meet your needs with new column in report view like this：

     

    Here is the demo , please try it:

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/admin_qiuyunus_onmicrosoft_com/EYLIDRoHizROkfp9iDEzHksB533NyLvsk-YiPkUhPx_92A?e=PkWqbo

     

    Hope it helps.

     

    Best Regards,

    Caitlyn Yan

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies