Forum Discussion

IvanSinelnyk's avatar
IvanSinelnyk
New Member
4 years ago
Solved

custom data labels

Hi everyone.  Need help. I have column with number of seconds (number type) and I need that big numbers (~32 000 000) transform to days, hours ... I allredy made it with DAX. But can't use this resul...
  • v-yingjl's avatar
    4 years ago

    Hi IvanSinelnyk ,

    Text value could not be used in the Value field if want to show like x days x hours x minutes x seconds. You can create a meaure like this to use it as a tooltip:

    Average = 
    VAR _avg =
        AVERAGE ( 'Table'[Time value(s)] )
    VAR _day =
        ROUNDDOWN ( _avg / 3600 / 24, 0 )
    VAR _hour =
        ROUNDDOWN ( ( _avg - _day * 3600 * 24 ) / 3600, 0 )
    VAR _minute =
        ROUNDDOWN ( ( _avg - _hour * 3600 ) / 60, 0 )
    VAR _second =
        ROUND ( _avg - _hour * 3600 - _minute * 60, 2 )
    RETURN
        _day & " Days " & _hour & " Hours " & _minute & " Minutes " & _second & " Seconds"

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.