Data Smoothing with Splines

Moderator
4120 Views
Highlighted
Moderator
Posts: 17
Registered: ‎09-29-2015

Data Smoothing with Splines

[ Edited ]

approval rating.JPG

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 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, powerbi.com

 

Legal Disclaimers:

Terms of Service and Third Party Programs.

 

Attachment
Attachment
Attachment
Regular Visitor
Posts: 36
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?

 

Thanks

Moderator
Posts: 40
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 
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