Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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
5 years ago

Presumably this is because the measure returns a text representation D:H:M:S .  You can't add this with another value - it doesn't make sense.

You might have a chance if you return a number (seconds, minutes or whatever)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    How can I return a number? I found the Measure on the internet, I'm not a DAX Expert 😄