How to do it...

To implement this recipe, do the following:

1. Create a measure using the following formula:

R08_Duration = 
    VAR __Duration = SUM('R08_Table'[Milliseconds])
    VAR __Hours = INT ( __Duration / 3600000)
    VAR __HoursRemainder = __Duration - __Hours * 3600000
    VAR __Minutes = 
        INT ( 
            MOD( 
                __HoursRemainder,
                3600000 
            ) / 60000
        )
    VAR __Seconds = 
        INT (
            MOD ( 
                MOD( 
                    __HoursRemainder - (__Minutes * 60000)
                    ,60000 
                ), 
                60000 
            ) / 1000
        )
    VAR __Milliseconds = 
        ROUNDUP(
            MOD(
                MOD ( 
                    MOD( 
                        __HoursRemainder,
                        3600000 
                    ), 
                    60000 
                ), 
                1000
            ),
            0
        )
RETURN
    __Hours * 10000000 + __Minutes * 100000 + __Seconds * 1000 + __Milliseconds

2. Create a Clustered column chart visualization and place the ID column in the Axis field and the R08_Duration measure in the Value field for the visualization.
3. Create a second Clustered column chart visualization and place the Group column in the Axis field and the R08_Duration measure in the Value field for the visualization.
4. For both visualizations, turn on Data labels and set the Display units to None.
5. Switch the Model view and click on the R08_Duration measure.
6. In the Properties pane, expand the Formatting section, set the Format to Custom, and enter 00:00:00 as the Custom format.