Reply
Maybrick1046
Frequent Visitor
Partially syndicated - Outbound

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.

 

1 REPLY 1
v-jialluo-msft
Community Support
Community Support

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)