Line Chart: Unable to set ACTUAL value on Y axis, Summarization is set to "Don't Summarize"

[smindia]

I am using line chart and not able to use ACTUAL VALUES on Y axis.

I have just two column date (date type) and stock (whole number) and Summarization is set to "Don't Summarize"

Still when I use line chart, I dont get an option to select actual VALUE.. all I see is SUM, AVG and other aggregate functions.

What am I missing here?

@amitchandak @Greg_Deckler @tamerj1  @lbendlin 

[smindia]

Thank you for your reply @HotChilli

My data has one value per x-axis value and I wanted to show an "Actual Value" and NOT the SUM, MAX, MIN etc aggregation.

I have attached sample.pbix file here to explain my issue in detail..

1) Table1 has one y-axis value per x-axis value

2) Table2 has multiple y-axis value per x-axis value

3) Table3 has multiple y-axis value per x-axis value but categorised by single column and 

4) Table4 has multiple y-axis value per x-axis value but categorised by multiple columns

and here are my charts respectively

I am NOT able to use ACTUAL value in any scenario. I am being forced to use SUM, AVG instead of actual value.

sample.pbix is saved on https://file.io/VgwyYRf9MCbK

Please advise.

Thanks

[HotChilli]

The line chart uses aggregations because it doesn't want more than one value for the same x-axis value.  If your data has one value per x-axis value then MAX, MIN, AVG will work