Forum Discussion
Graph Time duration
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 🙂
4 Replies
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.
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.
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.
