Why can't Power BI show these raw numbers in a line graph? (Any DAX suggestions) Screenshot.

[Pete_81]

I have this Excel data but when I try to reproduce the below chart in Power BI, it'll try to SUM or COUNT the P01-P13 data.

Which is obviously not what I want. I simply want Power BI to use the raw data.

I've double checked that Power BI is treating the values as decimal numbers and no other data type. There's no sigma (Σ) icons next to the data in the design view. ("Do not summarize" etc.)

I've been through many mnay Google search results pages as well as this messageboard, but am unable to find a solution.

Anyone got ideas please? Maybe a DAX solution would be best here?

Thanks.

[HotChilli]

We see this one frequently on the forum.  A line chart requires one value on the y-axis for one value on the x-axis therefore it forces an aggregation to be chosen. 

I suppose a design decision was taken to remove the 'do not summarize' option in line charts because it would cause confusion.

 If the data only has one y value for every x value then SUM, AVG, MIN, MAX will work 

[rajulshah]

@Pete_81 ,

Did you try changing the summarization?

If not, please try the following:

Select the column > you'll see Summarization on top ribbon. Then select don't summarize.

OR 

You can create a DAX Measure for the minimum/sum/maximum etc.

Also, from what I see in the image, it gives correct answer irrespective of the summarization.

Please let me know if this didn't help.

[Pete_81]

>Select the column > you'll see Summarization on top ribbon. Then select don't summarize.

Yes, this was done when importing the data.
The image displayed is from Excel, not Power BI.

What would be the best way to do the DAX measure? 

[rajulshah]

@Pete_81 ,

You can write the following DAX:

Total = SUM([YourColumn]) OR Minimum= MIN([YourColumn])

Unless and until I don't know the input and output thoroughly I can just guess the solutions.