09-15-2016 02:19 AM - last edited 09-15-2016 02:26 AM
09-15-2016 02:19 AM - edited 09-15-2016 02:26 AM
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:
dplyr, ggplot2, ggthemes, zoo
CRAN 3.3.1, MRO 3.3.0, powerbi.com
10-25-2016 11:25 PM - edited 10-26-2016 12:11 AM
I wish I'd seen this posting before I started my example...
My version uses the same ggplot and geom_tile functions as @fathomson but, rather than use R to massage the data with dplyr etc., it links directly to fields dragged from PBI - a typical Date dimension column and uses a calculated Time Bucket column as the other dimension against which to map the Call Count measure. I DO use the 'complete' function from the 'tidyr' package to fill in missing values and avoid holes in the heatmap.
I also played with presenting the value of the measure on the tile and some other formatting options. I tried to use the viridis palette package, but it's not supported on PBI Service yet.
Required R packages: ggplot2, ggthemes, tidyr. (see attached R script)
10-28-2016 12:52 PM
Here are the links to download the packages referenced:
Alternatively, you can install these throug R Studio by clicking on Packages > Install and entering the name of the package.
Hope that helps.
Victor Rocca | www.victorrocca.com
10-31-2016 07:53 AM