Heatmaps

Frequent Visitor
2677 Views
Highlighted
Frequent Visitor
Posts: 6
Registered: ‎09-15-2016

Heatmaps

[ Edited ]

heatmap.JPG

 

Description

An heatmap is a graphical representation of data where the individual values contained in a matrix are represented as colors. This R script shows an heatmap of calls received during the week. Based on the the timestamps it calculates the count per weekday/hour. 
  

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


Tested on:

CRAN 3.3.1, MRO 3.3.0, powerbi.com

 

 

Attachment
Attachment
Established Member
Posts: 164
Registered: ‎06-28-2015

Re: Heatmaps

There doesnt appear to be any R script attached to this topic?

Established Member
Posts: 248
Registered: ‎09-21-2016

Re: Heatmaps

[ Edited ]

I wish I'd seen this posting before I started my example...Smiley Happy

 

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)

Matrix HeatmapMatrix Heatmap

 

 

 

 

Attachment
Attachment
Regular Visitor
Posts: 49
Registered: ‎04-14-2016

Re: Heatmaps

Here are the links to download the packages referenced:

 

dplyr: https://cran.r-project.org/src/contrib/dplyr_0.5.0.tar.gz

ggplot2: https://cran.r-project.org/src/contrib/ggplot2_2.1.0.tar.gz

ggthemes: https://cran.fhcrc.org/src/contrib/ggthemes_3.2.0.tar.gz

zoo: https://cran.r-project.org/src/contrib/zoo_1.7-13.tar.gz

 

Alternatively, you can install these throug R Studio by clicking on Packages > Install and entering the name of the package.

 

Hope that helps.

Frequent Visitor
Posts: 6
Registered: ‎09-15-2016

Re: Heatmaps

@Steve_Wheeler Looks nice and thanks for adding the R installation script!

 

@vrocca Thanks! In R studio I usually use the install.packages('packagename') to add a new package. And above your script or markdown document library('packagename')