Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Are you looking for a measure as below?
Total Hours = VAR HoursInDecimal = SUM ( 'Table'[Hours] ) RETURN FORMAT ( TIME ( TRUNC ( HoursInDecimal ), 60 * ( HoursInDecimal - TRUNC ( HoursInDecimal ) ), 0 ), "HH:MM" )
Are you looking for a measure as below?
Total Hours = VAR HoursInDecimal = SUM ( 'Table'[Hours] ) RETURN FORMAT ( TIME ( TRUNC ( HoursInDecimal ), 60 * ( HoursInDecimal - TRUNC ( HoursInDecimal ) ), 0 ), "HH:MM" )
Hi @Eric_Zhang
I tried your solution, however, it is not serving one purpose for me. If I am representing time for a particular day it is working fine, however, when I change the time range to full week it does not work.
My requirement is to not only represent time on each row, I have to aggregate total duration for the selected time range as well (selected on slicers).
I, instead tried to break it down to Hours, minutes and seconds and then represent in text format to be able to serve my purpose.
MEASURES -
CALLTIMES = SUM(DURATIONINSECONDS)
HRS = TRUNC([CALLTIMES]/3600)
MINS = TRUNC((([CALLTIMES]/3600)-[HRS])*60,0)
SECS = TRUNC((((([CALLTIMES]/3600)-TRUNC([CALLTIMES]/3600))*60)-[MINS])*60)
TIMING = IF(LEN([HRS])=1,"0"&[HRS],[HRS])&":"&IF(LEN([MINS])=1,"0"&[MINS],[MINS])&":"&IF(LEN([SECS])=1,"0"&[SECS],[SECS])
I would not have to take a long route if there was formatting available in Power BI visuals, like we custom format in excel = [h]:mm:ss
Since this threads is old and already closed, please raise a new thread for your question. Thanks for your understanding. 🙂
Okay. I will go ahead and do that.
One way to force Power BI to allow a time number format is to add TIME(0,0,0) to the existing measure.
To ensure blanks are still blanks, you can do something like this:
MeasureTimeFormat = VAR OriginalMeasure = [OriginalMeasure] RETURN IF ( NOT ( ISBLANK ( OriginalMeasure ) ), OriginalMeasure + TIME ( 0, 0, 0 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |