topic Map with connecting lines in R Script Showcase

Map with connecting lines

ankitpatira — Thu, 20 Oct 2016 08:26:53 GMT

Description

This visual uses Maps package and Geosphere package to draw a map of Australia and dots on that map finally connecting them with lines. Using sample migration statistics data from different cities within Australia to the city of Melbourne, R visual shows the trend of migration by color coding the lines and shading higher count cities on top of the lower ones.

Prerequisites (The sample .pbix files won't work without installing the following)

1. Install R Engine

Power BI does not include the R engine. Therefore, a seperate installation is required to install R on your local computer.

Required R Packages

Maps

Geosphere

Tested on

MRO 3.3.1, CRAN 3.3.1

Re: Map with connecting lines

Sharon — Fri, 21 Oct 2016 21:19:02 GMT

this is so cool Ankit!

Re: Map with connecting lines

boefraty — Tue, 22 Nov 2016 10:53:54 GMT

Hi Ankit,

This visual is very impressive. If you consider to convert this or some of your other R-visuals to R-powered-custom visuals, out team will be happy to assist you.

The visibility of R-powered custom visuals is greater and it is not limited for R-users.

Re: Map with connecting lines

paul_turley — Sun, 21 May 2017 07:00:04 GMT

To get this R visual script to work, users will need to add the following commands before the two libray function calls:

install.packages("maps")
install.packages("geosphere")

Re: Map with connecting lines

JoseMiguelPR — Wed, 31 May 2017 08:46:31 GMT

Hi Ankitpatira,

thanks for the visual. Really great one.

Hi Paul,

Can we install these packages before even having R installed? and sorry for the question but... how do we install packages?

thanks for your help

/Jose Miguel

Re: Map with connecting lines

boefraty — Mon, 17 Jul 2017 14:25:08 GMT

Hi JoseMiguelPR,

You need R engine installed to run R in Power BI. You can use any R IDE (like RStudio) to install packages

See more here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-scripts/

Re: Map with connecting lines

gurukpm — Thu, 25 Jan 2018 04:23:08 GMT

Could you please include the files used in R Get Data Script.

Cities.csv, migrations.csv

Re: Map with connecting lines

gurukpm — Thu, 25 Jan 2018 04:39:28 GMT

Could you also add the Get Data R Script support files (Cities.csv, migrations.csv).