Data Smoothing with Splines

Description Smoothing helps you to better visualize and understand noisy data Prerequisites (The sample .pbix files will not work without these prerequites completed) 1. Install R En...

Smoothing Splines Showcase.pbix561 KB

ScriptInstallPackagesWithWorkaroundsSpline.R1 KB

General R Visualizations

boefraty

Microsoft Employee

9 years ago

Hi, sorry for the delay in reply.

The X column is of type "numeric". You can convert "date" type to "numeric" in Power Query. Next you need to take care of X-axis ticks labels, to be formatted as you want.

I did something similar in
https://community.powerbi.com/t5/R-Script-Showcase/ARIMA-forecasting/m-p/124237

Please have a look at the R code. If you still have trouble with it, you are welcome to send me the PBIX

Anonymous

Not applicable

8 years ago

Been looking at this visualization lately as I need to plot some datapoints and need to add regression lines. I'm plotting revenue/sales per day, and using the date as the category/legend. However, I need one line for each of the days, instead of one for all the data points.

How much work am I looking at doing smoething like this in R?