Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dbakeg00
Regular Visitor

Building a pump curve and then plotting other points (for pump performance) against it

Hello.  I'm new to PowerBi.  My objective is to build a curve for pump performance (flow on the x-axis and pressure on the y-axis).  These curve performance numbers would be from the original performance test (when the pump was new).  Additionally, I would then like to plot the performance of the pump in the subsequent years...except the pump is not tested at all of the flows it was during the original test thus I would only need to plot 2-3 points in a given year rather than the entire curve.  Hopefully, my description is clear.  I've included a graphic as an example to show the final product looks like in my mind.  In this graphic, the line with the yellow dots is the original test and then the individual colored dots are subsequent years (color coded by year).  

 

Like I said, I'm new at this so maybe what I'm asking is obvious.  Thanks in advance.

 

dbakeg00_0-1655223059118.png

 

2 REPLIES 2
Anonymous
Not applicable

Hi @dbakeg00 ,

 

Please take a look at Spline chart.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380860?tab=Overview 

 

Best Regards,

Jay

Hi Jay.  Thanks for the response.  I looked at a spline chart and—if I'm understanding it correctly—it seems that it plots a line that is the average of a group of scatter plots.  If that it true, I don't believe it will work for me as I need to plot a function (as a line) and then plot a few independant points as scatter plot.  If my assumptions are incorrect, please let me know.  Thanks again.

 

-Dustin

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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