Data Smoothing with Splines

Posts: 17
Registered: ‎09-29-2015

Data Smoothing with Splines

[ Edited ]

approval rating.JPG


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 Engine

Power BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately installR on your local computer. You can download and install R for free from many locations, including the Revolution Open download page, and the CRAN Repository.


2. Install the required R packages.

Download the R script attached to this message and run it to install all required packages on your local machine. 


Required R packages:

graphins, spline, scales

Tested on:

CRAN 3.3.1, MRO 3.3.0,


Legal Disclaimers:

Terms of Service and Third Party Programs.


Regular Visitor
Posts: 38
Registered: ‎07-29-2015

Re: Data Smoothing with Splines

We love this visual.  How should the script read if my dates are formatted as mm/dd/yyyy?



Posts: 86
Registered: ‎08-10-2016

Re: Data Smoothing with Splines

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

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