Reduce the number of data points for X by adding range

[PBIBee321]

Hi All,

I basically want to plot a line chart with the below values:-

Now the challenge is instead of plotting against all the values in X axis , I want to plot the X axis in a range like  0,0.1,0.2,0.3 and so on and the values for the x that lies between x = 0 to 0.1 should be plotted against all its value for Y but not as individual points . so basically X should have 0,0.1,0.2,0.3  for the below values and all the values of X against Y should be plotted in the range 0,0.1,0.2 and 0.3 instead of plotting them as inidvidual points because it will make the X plot too big so I want to divide it into subcategory.If I individually mark X against Y as per my source table then it will occupy a lot of space and will not fit the view as well 

Please advice if any measure or calculated field or data table can handle this line chart.

My Source table is as below :-

X	Y
0.09424	101.2
0.09728	101.2
0.1003	101.2
0.1034	101.2
0.1064	101.2
0.1094	101.2
0.1125	101.2
0.2098	102
0.2128	102.7
0.2158	102.7
0.2189	102.7
0.2219	102.7
0.225	102.7
0.301	103.5
0.304	103.5
0.307	103.5
0.3101	103.5

Guttu

[tamerj1]

Hi @PBIBee321 
You can create a new column X1 = ROUNDUP ( 'Table'[X], 1 )
Then plot X1 against MAX ( 'Table'[Y] )
unless X and Y are measures?