• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power BI dashboard time chart

ushaanu

Member
HI All,

I am new with power BI . i have customer service calls data like how many calls done and what is the response time (given in decimal value) on different product category.

i need product category in filter. and showing chart of calls logged and Average response time against product category.

i tried and make calls logged count but when i make response time chart it`s show decimal value and i need in HH:MM average response time chart. i try to convert response time value in HH:MM in raw file but when i create chart in power BI it`s not working .

raw data enclosed.

TIA

Anu
 

Attachments

  • Book1.xlsx
    23.7 KB · Views: 3
Hello @ushaanu

As you are new to Power BI I recommend you to go and check powerbi.microsoft.com/en-in/. To achieve your goal load your raw data into Power BI first and then you have to create a new column to convert decimal response times to HH:MM format with this given formula : FORMAT(TIME(0, INT([ResponseTime]), 60 * ([ResponseTime] - INT([ResponseTime]))), "HH:MM").'
And don't forget to use the Product category as a filter.

Hope this will display your data as desired.
 
Back
Top