time show on visual not same type as data

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[PhilipTreacy]

Hi @Anonymous 

Can you please supply your PBIX so we can see what you are doing.

Regards

Phil

[amitchandak]

@Anonymous , refer this old post, if this can help.

https://community.powerbi.com/t5/Desktop/Having-date-and-hour-on-the-X-axis/td-p/730450

I see few idea around it -https://ideas.powerbi.com/ideas/search-ideas/?status=&q=hour%20on%20axis

[Anonymous]

@amitchandak i can put on x axis now, but its not show anything on visual

[amitchandak]

@Anonymous , You can create a time table and use that as axis

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[Anonymous]

i was tried it but its doesnt work, its not allowed me to place time column in x axis field