Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

What the heck is the problem?

Hello, I have a measure to sum the duration of minutes to hours. The problem is, its working perfect but only as a table or matrix?! I can not put the measure to the fiel values to make eg. a bar ch...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    As HotChilli said, your measure returns a text which could not be plotted on a chart(Y-axis) .

    So you could only apply TotalSeconds to Y-axis instead because it is a number value . And then drag your measure to Tooltips.

     

    Or you could change TotalSeconds to Duration in Power Query as shown below:

    Output:

     

    Or refer to this blog:https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

 TotalSeconds is the only one that is correct for the whole total

The other variables all work from TotalSeconds -> the final result is a text representation of TotalSeconds split into Days,Hours,Minutes,Seconds.

I haven't looked at in detail but it seems right.  You have to decide what you want to return.