Best method for smoothing the data in a line graph

[ScottPat]

I am trying to get a polynomial style curve however I hear that there is no direct way of doing this in a line chart currently?
I know this can be done in Deneb but if I went that way I'd need some guidance on that too.

I could settle for a method such as a rolling 3 month average (or any other method that reasonably smooths the data and that I can explain to users).

Also, I am currently using a parameter to display the data (sales/margin/volume/revenue) in the same graph and I am hoping to incorporate that and haven’t got very far. I also kept ending up with the wrong date range on the x axis when trying to enter the 3 months rolling average.

[Anonymous · Accepted solution]

Hi @ScottPat ,

As far as I know, currently Power BI doesn't support us to smooth line chart like the Excel. I think you need to create custom visuals. You may refer to attach file to try the "Advanced Line Chart".

Result:

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function: "Smooth" Line Chart, Area Chart
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hello @ScottPat  and @Anonymous 

From the july 2023 release - you can now change the line type to "smooth"-

See release note : Release note july 2023

or the snippet from the release note below to see how you can change line type to smooth:

Kind regards!

If this solved your problem, consider marking this answer as a solution.

[DHB]

I'm fairly sure PBI used to allow you to do this but that functionality was dropped somewhere along the way.

[Anonymous · Accepted solution]

Hi @ScottPat ,

As far as I know, currently Power BI doesn't support us to smooth line chart like the Excel. I think you need to create custom visuals. You may refer to attach file to try the "Advanced Line Chart".

Result:

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function: "Smooth" Line Chart, Area Chart
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.