Forum Discussion
Line Chart - Similar Problem but using numerical data
Hi Anonymous ,
Thanks for properly sharing the info.
I have checked it, it looks like this is standard feature of line chart and your data is that way. On one single date e.g. 30 Jun 2023, you show two data points and likewise many end dates have multiple energy readings, so if you plot a line chart with energy and end date, one single date on x axis has to show 2 data points or more, so it can show sum and count and so on but not the dont summarize option. Though if you use table visual for same data, you will see dont summarize option as well.
If you wish to see multiple data on one date, use some identifier as legend or with some other ways:
Hope it helps.
Hi mahenkj2
Many thanks for this.
Pls find link to both files shared from Dropbox: Link to pbix in Dropbox Link to xlsx in Dropbox
Peter
Hi Anonymous ,
Thanks for properly sharing the info.
I have checked it, it looks like this is standard feature of line chart and your data is that way. On one single date e.g. 30 Jun 2023, you show two data points and likewise many end dates have multiple energy readings, so if you plot a line chart with energy and end date, one single date on x axis has to show 2 data points or more, so it can show sum and count and so on but not the dont summarize option. Though if you use table visual for same data, you will see dont summarize option as well.
If you wish to see multiple data on one date, use some identifier as legend or with some other ways:
Hope it helps.
Hi mahenkj2 ,
Many thanks for your time on this. Peter