Forum Discussion
Line chart to show duration in Y-axis
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?
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
1 Reply
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