How to NOT get sum/count values in a line chart

[katto16]

Hey peeps.

I have pretty much worked with tables and matrixes. This is my first time using a line chart. I have various test readings that I want to show on a line chart but in the Values field, I can't seem to be able to do it. I just want to plot the readings as they are, not summing nor counting. I have played around with the column data type. I tried changing them to "General" "Decimal" but didn't solve my problem. I also set to "Don't Summarize" under Summarize under the column tools.

I saw some other posts with the same issue as mine but they don't seem to be resolved either. What could be the issue here? Is it the way my columns are built? I'm very confused and fraustuated as I can't do a simple line graph. 😕

And similarly, is there any way I could put two column values into a scatter chart? 

As I put another column value, it goes under the size field and I can't show normal test readings just like how I want to show in Y axix field.

Thanks everyone in advance.

[HotChilli · Accepted solution]

It depends on the visual that you use.  A table visual? no problem.

Line chart has to make a line so there has to be an aggregation involved.

--

What are you expecting to see if using a line chart with 2 or more values for the same x-axis value?

If there is a separate categorisation that can go in the legend, that would create another line but it would still use an aggregation.

That's my understanding.

[katto16]

Hi @HotChilli Thanks for the kind reply. After studying the visualization types in PowerBI, I understood more now.

Cheers!