Bar or Line chart for Time value.

[parthpatelalex]

Hello All,

I am trying to create a chart for total time taken on call. I have just two labels one is Name and another one is total talktime.
Below is the snip of it and I am not able to create a chart of it as it taking as count! anyone help me out how I can do this??

 

How I can create chart like below in power bi?

Please help me out with it!! Thank you in advance.

[lbendlin · Accepted solution]

You have the wrong X axis for a line chart.  There is no correlation between the names, so they should not be linked via a line.  A column chart is more appropriate.

[Anonymous · Accepted solution]

Hi @parthpatelalex ,

You may consider converting the time type to a numeric type. For example create a new calculated column and convert it to minutes:

Taktime2 = HOUR('Table'[Talktime]) * 60 + MINUTE('Table'[Talktime]) + SECOND('Table'[Talktime]) / 60

I also second lbendlin's suggestion to use column charts:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group

[Anonymous · Accepted solution]

Hi @parthpatelalex ,

You may consider converting the time type to a numeric type. For example create a new calculated column and convert it to minutes:

Taktime2 = HOUR('Table'[Talktime]) * 60 + MINUTE('Table'[Talktime]) + SECOND('Table'[Talktime]) / 60

I also second lbendlin's suggestion to use column charts:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group

[parthpatelalex · Accepted solution]

Thank you, I have convert the time into seconds and then asign actual data values to the Detailed Labels field and its works properly..

Thanks again 🙂

[lbendlin · Accepted solution]

You have the wrong X axis for a line chart.  There is no correlation between the names, so they should not be linked via a line.  A column chart is more appropriate.

[parthpatelalex]

Thank you! 🙂 Yes the column charts works perfectly for me!