Forum Discussion

shadedfern's avatar
shadedfern
Frequent Visitor
2 years ago
Solved

Don't Summarize not available?

I am trying to make a line chart with the x axis showing the dates from July 1 - 31. Each day has a corresponding translation time aka 'Duration'. So to re-iterate each day should have only one 'dura...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

    Have a reread of my previous post.  Maybe I have not explained it well.

    The data points are in Time datatype.  This is for times of the day: ten past 4, quarter to ten, etc.  Powerbi cannot add these together so it's not usable on the y-axis of a line chart.

    --

    You will need to convert them to a different (numeric) datatype

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Line chart needs a numeric value on the y-axis.  The Time datatype is for times of the day. You will need to convert the values to something that makes sense on the axis, for example, minutes.  There are conversions available in various posts on the forum and in powerbi blogs

shadedfern's avatar
shadedfern
Frequent Visitor
2 years ago

HotChilli 

I have it set up based on the format (HH:mm:ss)

The values which I am trying to display on the y - axis are all minutes + seconds. I believe the one problem I am running into is that instead of dislpaying the actual values corresponding to each day, it is just showing the count per day which is 1 hence the graph just being a horizontal line at value 1.