Forum Discussion

parthpatelalex's avatar
parthpatelalex
New Member
2 years ago
Solved

Bar or Line chart for Time value.

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 ...
  • lbendlin's avatar
    2 years ago

    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's avatar
    Anonymous
    2 years ago

    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's avatar
    parthpatelalex
    2 years ago

    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 🙂