Forum Discussion
Solved
Time Duration and Time Graph Plotting
Hello Everyone, I am new to Power BI. Looking for some help. Earlier I use Excel and Power Point to present Weekly Report. Now i have started in Power BI. I use to compare average resolve time we...
Hi Avichal ,
You can try this:
1. Duplicate column of ‘Duration’.
2. Split ‘Duration – Copy’ with ‘:’.
3. Add a custom column.
=[#"Duration - Copy.1"]*3600+[#"Duration - Copy.2"]*60+[#"Duration - Copy.3"]
4. Remove columns.
5. Create a line chart, put ‘Seconds’ in ‘Values’ and ‘Duration’ in ‘Tooltips’.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you tried time on the axis? By dragging it into the axis property of the graph and it still shows count.
Hello Amit,
Thanks for your help but it doesn't work :(
amitchandak wrote:Have you tried time on the axis? By dragging it into the axis property of the graph and it still shows count.
