Forum Discussion

tiagotas's avatar
tiagotas
Icon for Helper I rankHelper I
9 years ago

How to show average hours on graph

I am not able to average the hours shown in the table, nor to show the results of the hours in the chart. How do I create the average hour?

 

 

The Production Amount is correct, but the hours do not appear and I can not make the hour average!

Tips and Tricks

13 Replies

    • tiagotas's avatar
      tiagotas
      Icon for Helper I rankHelper I
      9 years ago

      I need to create the average hour.

      I am unable to display the hour and minutes on the power BI chart as per the information in the spreadsheet above.

      • MattAllington's avatar
        MattAllington
        Icon for Community Champion rankCommunity Champion
        9 years ago

        I ma happy to help you but you need to provide more Information. I'm sure you know what you need but it is not obvious from the information you have provided. What is the tempo column?  Is it time of day or total hours?  Given there is only 1 record per day, what is the average supposed to be?  Please provide a sample of the result you need.