Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 Y axis can only have numerical values, so my existing "MM:SS.ms" strings won't work in the graph. I can fix this by converting them to seconds.
This fixes the problem & gives me what I want, except for one point: now I'm looking at seconds when my users need to see the time as MM:SS.ms.
Ultimately what would be ideal is to tell the line graph "use seconds when plotting everything, but in the display, only use the "MM:SS.ms" in the Y axis and data label while the dates are on the X axis."
Does that make sense? Is this possible or are there other ways to achieve the same thing?
Solved! Go to Solution.
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.
Hi @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:
Does this help?
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:
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |