Sum Minutes and Display HH:MM on Bar Graph grouped by day

[willz06jw]

Hi and thanks for reading,

I have a column that contains minutes as a whole number

How can I sum the field that contains minutes as an integer, grouped by day, and display on the bar graph as HH:MM?

Thank you,

Will

[v-yulgu-msft · Accepted solution]

Hi @willz06jw,

If you add [Day] into X-axis of bar graph, add the field that contains minutes as an integer to "Values" of bar graph and choose "Sum" aggregation, it will sum up minutes automatically grouped by day. However, displaying the total value as HH:MM format is not possible. As Y-axis supports only numeric values currently.

Regards,

Yuliana Gu

[spirula]

Hi Will,

Could you post a snapshot?  I think you mean sum the column?

[spirula]

See Greg's response here:

https://community.powerbi.com/t5/Desktop/Display-HH-MM-SS/m-p/353799/highlight/true#M159224