- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Scatter Plots: Unsummarized Numeric Values Y Axis and Date as X Axis won't work
A Real Estate Appraiser using Excel can take two Excel Columns (ClosedDate) and (SoldPrice) select them all, hit scatter plot and add a trendline. Excel properly generates the X and Y axis when columns are in this order. The plot is wonderful, and the slope generated and the trendline inserted is easy-peasy.
I don't want summarized sold prices in PowerBI - it skews the regression. You cannot use a date as the X-Axis if the data is not summarized. How do I fix this?
Power BI DataSet
SoldPrice, DateSold
I drag DateSold to X-Axis and turn off summarize on SoldPrice. I get the error this can't work due to unsummarized data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Maybrick1046 ,
With your description, you need to display the data in the correct scatter plot.
Please provide sample files and expected output or screenshots to further resolve the issue.
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn
Best Regards,
Gallen Luo

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
61 | |
56 | |
55 | |
36 | |
34 |
User | Count |
---|---|
76 | |
73 | |
46 | |
45 | |
43 |