cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AgeOfEgos
Helper I
Helper I

Tracking time over a date range--insists on doing count

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?

 

Time in Columns.png

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @AgeOfEgos 

As tested, it shows correctly in this case.

If your problem still occurs, please show some screenshots with me for better analysis.

1.png

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.

 

 

 

 

 

Count.png

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].

14.png

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.Example.png

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.