How to do not aggregate values in the line chart

[Anonymous]

To whom it may concern,

I would like to ask you for your help.  I have a problem with the line chart. I need to display non-aggregating data in a line chart. In other words, I would like to display in the line chart exactly the data that I have in the source table.

I have these data type:

x-axis: Date

y-axis: Decimal Number

Line Chart wit average aggregation

I have about 45 000 lines in my table and date Date are not continuous. I have data from 1.3.2019 and after from 7.3.2019, not for each day in calendar. This data are data for individual purchases of material converted to a "currency / unit of measure" (Decimal Number) in order to measure whether our purchase prices are like market prices.

Line chart without possibility to don't summarize

Today we use average, which does average from every purchase, which was made in the same day. For example, if I bought some article XX for 30 EUR/kg on Friday (12.3.2021) and the same article XX for 50 EUR/kg at the same day. It makes from it the number 40 EUR/kg for 12.3.2021. But I must display two data for the same day. I must have in a line chart both values (so I need to have there 45 000 values and not for example 250 values, which are average for days when I purchased something).

I tried to do it with this code, which I found at Google, but it does not work.

" Name of the column = IF(HASONEVALUE('name of sheet'[column]),VALUES('name of sheet'[column]))"

Y-axis - data type - Date  X-axis - data type - Decimal Number

Thank you for your help,

Michal

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Value field is aggregated unless the non-value fields in the chart are unique.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

You don't answer the question. I have the same problem I want to display a line chart wich has one unique value by unit value of x axis wich is a index (1,2,3,etc.) The most basic chart ever !! And it impossible to do it !! Beause its aggregate automaticly and there is no "don't aggregate" !! Why ??  Whats the wrong with PowerBI !! Why is it so useless ?? Even with excel we can do it in 5 second !