Forum Discussion
Displaying time in line graph
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.
Community SupportHi andrewconnell ,
As you said, could you please clarify what the red line part is referred to ?
I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
It's not a "red line" I'm looking for... it's showing times over time... referencing the image below, you can see the table of data & the graph that does NOT show what I want... some points:
- The values in the graph currently shown is from the green box, but it wants to sum / count / etc... I want the Y axis to show the actual values, not aggregate them
- The date on the X axis should be the actual dates... not comparing year over year or month over month
- Ideally, the values I want to show up in the Y axis and on the data labels are from the purple box (Time (minutes)) but I understand that as a text field, I can't graph it... not sure if there's a way to say "use this property to create the chart, but use the values from this field for the Y axis.
Does this help?
- v-xicai
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.
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:
- v-xicai
Hi,
You can use "Sort by" to sort X axis , then choose "Sort ascending".
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.