Forum Discussion
Making date and time continuous
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?
1 Reply
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.