Forum Discussion
smindia
3 years agoRegular Visitor
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 ...
smindia
3 years agoRegular Visitor
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