Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to do not aggregate values in the line chart

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

  • 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.

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support

    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's avatar
      Anonymous
      Not applicable

      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 !