Forum Discussion

Icon for Resolver II rank

Resolver II

5 years ago

Solved

HH: MM: SS vs CalendarYearMonth Graph

Hey Everybody,

I am trying to graph HH:MM:SS (as an aggregate) vs CalendarYearMonth.

I cannot get anything to show up on my line graph when I put 'ACW___' into 'Values'. (The 'Axis' is 'CalendarYearMonth')

Here is the formula that I am using for 'ACW'

ACW___ =

VAR a = [ACW_Sum]

VAR hours = INT ( a / 3600 )

VAR minutes = INT ( MOD ( a - ( hours * 3600 ), 3600 ) / 60 )

VAR seconds = ROUNDUP ( MOD ( MOD ( a - ( hours * 3600 ), 3600 ), 60 ), 0 )

RETURN

TIME ( hours, minutes, seconds )

Here is the formula for 'ACW_Sum'

ACW_Sum = SUM(Metrics[ACW])

Thanks

Dan

Anonymous
5 years ago
i820017 jcampbell474

I am afraid you cannot display time type in the power bi graph. You may check the submitted idea: Microsoft Idea · field of "duration" type (powerbi.com)

For the workaround, please check the solution in the post:

Solved: Show measure HH:MM:SS in y axis - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

3 Replies

jcampbell474
Helper IV
5 years ago
I am also interested as I have a similar issue. The Time (after Return) value will appear in a table with a date column, but will not appear in any kind of graph with date on the X axis.

Is it a visual limitation? Any help will be appreciated!
Anonymous
Not applicable
5 years ago
i820017 jcampbell474

I am afraid you cannot display time type in the power bi graph. You may check the submitted idea: Microsoft Idea · field of "duration" type (powerbi.com)

For the workaround, please check the solution in the post:

Solved: Show measure HH:MM:SS in y axis - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
- jcampbell474
  Helper IV
  5 years ago
  Thank your for the reply! I voted on the idea 🙂