Aggregate Values are displayed on Y Axis instead of an Actual Value in Line Chart

[smindia]

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

[dikshabahal]

Hi Did you get any solution ? I am also facing same issue. For me on x axis its date and I have to show multiple values on a particular date on line chart.

[galaamri]

Hi @smindia 

I see where your confusion is. In your data you have multiple prices for the same date, so when Power bi maps the date, it will have more than one value to choose from. As a result, BI will aggregate the prices. 

[smindia]

Please have a look at Table 1 and Chart 1..

In Table 1, there are no multiple values against same date.. Each row has unique date and price but still there's forceful aggregation.

[galaamri]

In fact, it actually sums the values but since they are only one value against each date, it appears like the actual. 
Best suggestion:

try to add unique value for each price  row like index so you can see the actual prices or change the type of visual. 
hope this helps 

[smindia]

Dont Summarize, Type Change, Indexing nothing works when it comes to Line Charts.. Aggregation is being forced

[galaamri]

Hi @smindia 

I see it is still aggregated "sum of price" there is "^" so you should see don't summarize. If not 

then change price to text type. 
hope this helps 

[smindia]

1) Where's that "^"? Can you please point it out in the screenshot? Are you taking about a dropdown?

2) I tried and changed the price to text type, but still seeing same issue. Please see below screenshot

[smindia]

Thanks for your reply @galaamri 

Price was already set to "don't summarize", Pls see screenshot below

[galaamri]

Hi @smindia 

You should have an option says "don't summarize". This will return the actual values. 

when you drag the field then Click "^" and you check don't summarize