How to avoid Line Chart doing unwanted aggregation?

Question

Hi Everybody,&nbsp;I took a Power BI online course, but I think I still need help to understand how this basic thing should work. In Power BI Desktop reports, when using the Line Chart visual to display a simple dataset with x/y values, the visual always apply some aggregation (such as sum, count, ..) to the y values, which is not what I want. I only want it to simply plot the x-y values without any aggregation, but don't know how to do that.&nbsp;Below is an example.1. First of all I have a table recording the adjusted annual GDP of a country for the beginning of each quarter. I want to use the Record Date for X, and Record Value for Y.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2. After creating the Line Chart visual, I drag-and-drop the table fields to the visual like the screenshot below. Notice that the Y-axis field automatically becomes "Count of", and the chart shows a straight line.&nbsp; &nbsp; &nbsp;&nbsp;3. When I attempted to remove the "Count" operation, I found that it doesn't give me that option. I need to chose one of the aggregation methods.&nbsp;4. I selected the "Record Value" field from the "Data" panel, and made sure there is no summerization from the ribbon at the top, but it doesn't help.&nbsp;Can you tell me how I can remove the automatically added summerization/aggregation?&nbsp;Thank you!&nbsp;Sui&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi Everybody,&nbsp;I think I understand how it works now. I just need to use the "Sum" aggregation, because every date only has one value in the table, and the sum of one value is itself.&nbsp;&nbsp;Thank you!

Forum Discussion

Related content

Unwanted Rounding Issue

Unwanted White marker in area chart

autosum unwanted

Unwanted Aggregation with dynamic Ranking

Data Aggregation issue