Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I wish to use a Line Chart visual to plot monthly utility usage for Gas & Electric meter readings. My meter data is sourced using dates and numbers in Excel. The readings are simple numbers not calculated values.
I wish to plot Energy Readings (y-axis) vs Time (x-axis).
Even though both the Excel and Power-BI Data type are both numerical and the data column is set to 'Don't summarize' when I drag the data into the y-axis well it is aggregated and labelled as 'COUNT OF...'. There is no 'Don't Sum' option offered.
I have found the document help page, 'Work with aggregates (Sum, average and so on) in Power BI', helpful but am still unable to solve the problem.
Thanks
Solved! Go to Solution.
Hi @Peter-SDB ,
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 @Peter-SDB ,
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 @Peter-SDB
Pls post a sample data, better excel and power bi file both after removing any sensitive data.
Else paste data so as to simply copy, but better if u post in Excel and power bi file, easier to simulate.
Hope it helps.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |