Forum Discussion

thomascampbell's avatar
thomascampbell
New Member
5 years ago
Solved

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...
Need Help
  • thomascampbell's avatar
    thomascampbell
    5 years ago

    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!

thomascampbell's avatar
thomascampbell
New Member
5 years ago

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!