Forum Discussion

New Member

7 years ago

Solved

Displaying time in line graph

My data source is a collection of elapsed race times over multiple dates. My goal is to display a line graph showing the progress of these elapsed times over the dates they occurred. I understand the...

Need Help

v-xicai
7 years ago
Hi,

You can create time column like DAX below, set the Time(seconds) "Sum" ( because it have been set show value as "No calculation" by default, so it won't be aggregated in fact ).

Time = FORMAT(SUBSTITUTE(Table1[Time(minutes)],".",":"),"H:mm:ss")

Best Regards,
Amy

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

andrewconnell

New Member

7 years ago

Much better... thanks! However, I'm having one challenge with this: the X axis isn't sorted correctly. I want the dates to be continuous, not based on the values. Notice from the screenshot below the dates aren't in ascending order... that's what I need to see... the most recent date on the far right, the oldest date on the far left... the highlight shows just an example of how the dates are out of order, but it's really the whole chart: