Creating a line chart using non summarized values

[desaitapan1]

Hi,

I need to show line chart where x-axis has time and y-axis shows glocuse level. when i put this on chart, y-aixs only gives me option to summerize glocuse level. I dont see "Don't Summerize" option. In Model i have set glocuse level column "Don't Summerize". any help would be greatly appriciated. 

Time	Glocuse Level
02:09:54	97
02:14:54	97
02:19:54	99
02:24:54	103
02:29:54	104

Looking for something like this that i was able to do easily in excel,

[danextian · Accepted solution]

Hi @desaitapan1 

Any field added to the value or y-axis tile of a line chart will need to be aggregated/summarized one way or another based on another field/x-axis. Looking at the times which are hard to read due to orientaiton, there aren't repeated ones.  If you want to make it look like that in Power BI change you y-axis to categorical insead of continuous.

[Deku]

The summarization would only apply if there multiple values for a specific time. Otherwise any of the summarization would be that of a single value.