Making date and time continuous

[Anonymous]

Hi!

I am trying to make a line chart where I have the time in the x-axis and some value in the y-axis. I want the x-axis to show time, date, month and year. However, with the date I cannot directly show the time. So, I made different columns of date format (dd:mm:yyyy) and time format (h:nn:ss) and used hierarchy in the x-axis. I am able to plot the values but as I try to make the x-axis type continuous it isn't possible. How could I fix this problem?

[Anonymous]

Hi @Anonymous ,

This is currently by design without any formatting options to change. 

Based on my previous test, when you narrow the dates range to display only 2 ~ 5 dates on the axis, the time values will appear. However, when displaying one date or more than 5 dates, it works well without the time values. Unfortunately, there is no solution or workaround at present. Please vote up the idea about this. topic: https://ideas.powerbi.com/ideas/idea/?ideaid=1fe223dc-e4fd-4139-ba66-186753425354

Best Regards,

Neeko Tang

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