Graph Time duration

[doriel]

Hello, friends. I am new to this forums and also new to the Power BI.

I understand the fundaments and I like the Power BI environment. Thank you for this forum, looks very nice.

But I sometimes struggle with the graphical interpretaion.

For Example, I wanted to create a graph, where X-Axis will represent categories (DownReason Empty, D00, D01, D02, ..).

And Y-Axis will show, how long aech category lasted.

I created column "Duration", but if I put that in graph, I get quantity of DownReasons.

Lower graph is flat, because it shows quantity DownReasons. How can show the time, instead of counting DownReasons?

I cant find it anywhere. Am I missing something trivial? I want to learn this, pleae help 🙂

[mahoneypat · Accepted solution]

Please see if this article helps.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[doriel]

Thank you very much for your solution, now I have a graph with real values, I tried to handle the date as a number (not duration) and this workaround works.

But now I have numbers in the graph, not duration, which is not desirable to me. There must be some simple way. I am sure I am not the onlyone who wants to show duration in graph. I must be doing something wrong.

[doriel]

I transformed the number into readible form by multiplying by 1440 (number of minutes in day). Now it ssems reasonable 🙂

But I still do not understand, why Power BI cant put time on Y-axis. Thanks Pat for assistance.

[doriel]

I think I have to "untick" the count/quantity in front of the Y-Axis value, but I just cant "untick" that..

Sorry for the czech localisation, I hope you get my point.. I am not native english speaker.