How to show only the max of a time column per date in a graph

[BJGRUNDY]

Hi,

I am trying to show the maximum time that a task has taken on any given day but when I try to add it to the graph it only does a count of and not max. I have tried various oprion but cannot seem to work it out.

[BJGRUNDY]

I cannot use the maximum fucntion as its time, it will only count.

[Anonymous]

Hi @BJGRUNDY ,

-- I cannot use the maximum fucntion as its time, it will only count.
Is the data type of this column text? Try to convert it to the appropriate data type.

If this doesn't work. Consider providing some non-private data as well as expected outputs, that would be helpful, thanks~!
How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Data-estDog]

Then you need a new column/meaure that is not the time it takes, but the duration. 
Something like this: 

DURATION = DATEDIFF(Table1[STARTDATETIME], Table1[ENDDATETIME], MINUTE)

Then add the  Duration column to your viz and set it to max instead of sum or count.

[BJGRUNDY]

Thank you for this, but it will not let me reference the table. Am I missing something?

[Data-estDog]

I said Column/Measure. I should have said column. Go to the table view and add a new column to the "Turn Around" table by right clicking on the table. That will let you build the duration column. Then You can build the MaxDuration measure or just add it to the graph with Max selected.

[Data-estDog]

2 options here:
1: Change the Aggregate type of the Y axis:

2: Create a new measure. Like this: (obviously change the field names if I don't have them right, guessing here)
Max Total Time = Max(Total_Time)

Add the new measure to the Y-axis of your graph and remove the other field. 

If I answered your question, please mark my post as solution, Appreciate your Kudos 

[BJGRUNDY]

I have managed to fo this, but it is still not showing as an actual time.