Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a custom column that computes the duration/datediff of two separate dates. It's working fine and when I put this into a standard data grid, it appears appropriately (see below).
However, when I attempt to do a line graph showing the time over a date axis--it insists on doing count. If I try max, it appears it sums it over the date range--and gets larger. How can I do a date axis with the duration for each date?
Hi @AgeOfEgos
As tested, it shows correctly in this case.
If your problem still occurs, please show some screenshots with me for better analysis.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I can't remove the count, it only gives me options of max/min/etc. even though the custom column is not summarized.
The custom column is figured by this formula;
Time Tracking = DATEDIFF(Sheet1[Report Final],Sheet1[Exam Complete],MINUTE) * -1
Thanks.
Hi @AgeOfEgos
@AgeOfEgos wrote:I can't remove the count, it only gives me options of max/min/etc. even though the custom column is not summarized.
When you add a column in the "value" field of a line chart, it will be summarized by default.
You could create a measure as well
Measure Time Tracking = DATEDIFF(MAX(Sheet8[Report Final]),MAX(Sheet8[Exam Complete]),MINUTE) * -1
Since there are mutiple line data for a single datetime point of [Exam Complete], the Time Tracking should be sum for each datetime point of [Exam Complete].
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the help.
When I plug that formula in--I am only getting one result per date instead of multiple. I think it has something to do with my date column. See photos attached.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
101 | |
74 | |
70 | |
48 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |