Forum Discussion
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...
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
Community Champion
Community ChampionWhat's the datatype on the column? I suspect it's been changed to a text field.
This is what I see when I click on the column in the Data tab:
It is Data Type: Time
And set to Don't Summarize