Plotting values on y-axis

Question

Hi ,&nbsp;I have 2 columns&nbsp;1.dat and time2.program number&nbsp;i am using line chart, with values below:&nbsp;x-axis : date&amp;timey-axis:program number.&nbsp;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.&nbsp;example data set:Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;programenumber29-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10128-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10128-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10228-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10329-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10229-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10427-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10527-3-19 09:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 101&nbsp;please help me here&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous&nbsp;,
&nbsp;
You may&nbsp;take advantage of the Legend field.
https://community.powerbi.com/t5/Desktop/graph-trouble-summing/m-p/564094#M266151

Forum Discussion

Plotting values on y-axis

1 Reply

Related content

Dynamic Y axis on DateTime X axis

Y Axis showing Sum or Count, not actual values

Dynamic y-Axis calculation with Deneb

Bar chart showing 2 level Y-Axis

Change Y axis interval