Solved: Line chart to show duration in Y-axis

Anonymous · ‎08-23-2022

The requirement is to show the jobs that ran every day by time duration in a line chart.

X-Axis : Date/Month/Year

Y-axis. : Job Duration (e.g 1 day 5:15:56 ( n day hh:mm:ss)

Legend : Job Names

As the Job duration is textual value, the line chart aggregates the value.

Is it possible to display job duration by day in a line chart? Is there any custom visual that can do similar things?

Anonymous · ‎08-26-2022

Hi @Anonymous ,

You can try to create a calculated column to convert the job duration to the number of days/hours, and it will be a numeric type. Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Please refer the following link to get the number of hours from duration:

Duration Calculation across days

Best Regards

View solution in original post

Anonymous · ‎08-26-2022

Hi @Anonymous ,

You can try to create a calculated column to convert the job duration to the number of days/hours, and it will be a numeric type. Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.