Import all data points from Excel

[Jim0101]

I'm trying to import a number of data points into Power BI from excel but the data points will only come as a sum and not all the data.

My Excel is formatted like the table below with several columns of data. Each Yx value is paired with the X.

X	Y1	Y2
2	37.2205	32.2783
3	45.302	39.1099
4	53.2248	45.3776
5	60.9805	51.3613
6	69.1999	57.3914
7	77.5866	63.2584

When I import the data I only get the sum of values in the column. I want to work with all the data points in each row. How do I import (uncalculated) raw data?

[Anonymous]

Hi

Go to Visualization -> RIght click the field-> Select "Dont Summarize" option.

 

Now you will get your raw data.

Thanks

Raj

[Jim0101 · Accepted solution]

I updated my software version and it's now working as expected.

[Jim0101]

Thank you for the reply but that option is not avaliable.

No option avaliableCoulmns are summed