Forum Discussion

smindia's avatar
smindia
Regular Visitor
3 years ago

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

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 

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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

  • smindia's avatar
    smindia
    Regular Visitor
    3 years ago

    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