Plotting values on y-axis

[Anonymous]

Hi ,

I have 2 columns 

1.dat and time

2.program number

i am using line chart, with values below:

x-axis : date&time

y-axis:program number.

When idraw line chart on Y-axis it is shwoing sum of all program number but i want to display only program number without any aggrigation.

example data set:

Date                                 programenumber

29-3-19 09:30                  101

28-3-19 09:30                  101

28-3-19 09:30                  102

28-3-19 09:30                  103

29-3-19 09:30                  102

29-3-19 09:30                  104

27-3-19 09:30                  105

27-3-19 09:30                  101

please help me here 

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take advantage of the Legend field.

https://community.powerbi.com/t5/Desktop/graph-trouble-summing/m-p/564094#M266151