Forum Discussion
TimeChart in PowerBI? Is it possible?
I have created a chart like the following in Excel. I would like to publish this type of data to a PowerBI Dashboard and then allow personnel in my company to see the data through that Dashboard. I can't figure out how to get this chart to work in PowerBI. I've seen other posts that talk about it too...but wanted to provide my context to see if someone can give me an idea how to do it. We are attempting to promote PowerBI in our company and this would help. Thanks.
GOAL: Publish Batch Times from a system in a chart in PowerBI.
Datasource: Azure SQL Server
Currently how it works in Excel: Refresh the query against Azure SQL Server Table, Then the chart updates.
Raw Data if it helps.
| Datetime Format m/dd h:mm | Datetime Format hh:mm:ss | DateTime Format hh:mm:ss |
| Datetime | Batch Run Time | Target |
| 11/05 8:00 | 00:02:34 | 00:02:00 |
| 11/05 8:04 | 00:01:34 | 00:02:00 |
| 11/05 8:06 | 00:01:46 | 00:02:00 |
| 11/05 8:09 | 00:02:53 | 00:02:00 |
Here's what I ended up doing.
I changed the time calculation to a decimal. So 90 seconds becomes 1.5 minutes. 220 seconds becomes 3.67 s, etc.
Then I plotted the "minutes" as a decimal on the Y-axis. This worked. The value to it as well was that for multiple charts on the same report, I could control the y-axis more easily by just setting the lower and upper bounds by number.
Thanks for your help!
4 Replies
thomascampbell , I doubt That in power bi you may not be able to plot time on y-axis. You may to convert that to duration
Do you mean that I should make the batch run times...numeric instead of time and plot that somehow? That would work...but not ideal. It's easy to do in Excel...why an issue in PowerBI?
Hi thomascampbell ,
The'Line chart' can not plot time type data.
You need use a custom visual.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here's what I ended up doing.
I changed the time calculation to a decimal. So 90 seconds becomes 1.5 minutes. 220 seconds becomes 3.67 s, etc.
Then I plotted the "minutes" as a decimal on the Y-axis. This worked. The value to it as well was that for multiple charts on the same report, I could control the y-axis more easily by just setting the lower and upper bounds by number.
Thanks for your help!
