Data Smoothing with Splines
08-15-2016 09:37 AM - last edited 11-16-2016 01:29 AM
08-15-2016 09:37 AM - last edited on 11-16-2016 01:29 AM by boefraty
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
CRAN 3.3.1, MRO 3.3.0, powerbi.com
04-22-2017 11:56 PM
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