Chelsie Eiden's Duration
Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...
Hi Greg!
Formatting the value works properly, but I think we cannot visualize it
because the 1:00:00 bar shouldn't be ~40% larger than the 00:59:50 bar, since the difference is only 10 seconds (<1%), right?
Since May you can solve this problem by using measure calculating only minutes in y-axis and original measure on custom data label.
Take hours out of the original measure:
duration in minutes =
VAR Duration = SUM(Sheet1[Call Duration total seconds])
VAR Hours = INT ( Duration / 3600)
VAR Minutes = INT ( MOD( Duration - ( Hours * 3600 ),3600 ) / 60)
VAR Seconds = ROUNDUP(MOD ( MOD( Duration - ( Hours * 3600 ),3600 ), 60 ),0)
RETURN
(Hours * 60 + Minutes) * 100 + Seconds
And use the original measure in Visual->Data Labels->Values->Custom label. Maybe hide y-axis if you feel like it.
Like this
It would be great if you could show how this is now being done with an example please? Thank you!!
