Visual shows wrong data/ invents values

[HenX]

Hi,

I have a small dataset that contains the bodyfat (called here "brozek" because of the used calculation method) and and the density of random people. There is definitly a linear relationship between both values. The Problem is, in a line chart visual the result looks like shown in the image below. All the red marked peaks are wrong aka values that don't exist in my dataset.

If I create a card visual with the max of brozek (y-axis) one can see that the max value is soemthing around 45 and the peaks are obvious "fake" values, invented by the visual.

The same strange behavior can one see in the scatter chart visual. If I try to plot the relation between weight (y-axis) and height (x-axis) of a person, I get the following chart.

All the red marked points don't exist in my dataset. The only way I can overcome this is by forcing the x-axis range maximum to the maximum height.

Update:    Interestingly even the median lines are different. Though both are just selected under the analytics button (no own Dax formula) they plot me two different lines......

I guess, I'm using the visuals in the wrong way, but I don't get it. Maybe someone can give me a hint.
Thx HenX.

[James-Harpin · Accepted solution]

Hello @HenX ,

What is the summarization you're using for the brozek column? On the first chart perhaps you have multiple brozek values for density and the brozek column is summing those values for each density value?

[HenX]

The solution for the other issues is also the aggregation function. If I select "don't summarize" it works as expected. 

[HenX]

Thanks @James-Harpin,
yes you were right. There were multiple brozek values for some density values and were summed up. By using Average the chart is as expected. 🙂