Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 'duration' attached to it.
I figured out how to fix the duration column to reflect the actual minutes and seconds. However the newest problem I am running into is trying to make it so powerBI does not summarize or COUNT the duration values. I am trying to make a line chart show the actual duration value corresponding to the day.
As you can see in the screenshot above, the table on the right shows all the correct values in the appropriate format. However what is shown on the line chart is the count per day which is 1 instead of individual values shown in the table on the right.
In the Data tab I set the duration column to 'Don't Summarize', this does not do anything in terms of correcting the visual.
Also in the Report tab, when I right click the Duration field under the Values for the line chart I see this:
With no option to 'Don't Summarize'.
I clicked the Data Tab, and I set the Duration column to Don't Summarize there but it doesn't seem to have any effect on the visual...
Is there any fix??
Solved! Go to Solution.
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
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
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
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.
What'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
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |