<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/interactive-r-visuals-in-power-bi/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2017/06/interactive-r-visuals-in-power-bi.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p>Power BI has long had the capability to <a rel="nofollow" href="http://blog.revolutionanalytics.com/2016/08/powerbi-and-r.html" target="_blank">include custom R charts in dashboards and reports</a>. But in sharp contrast to standard Power BI visuals, these R charts were static. While R charts would update when the report data was refreshed or filtered, it wasn't possible to <em>interact</em> with an R chart on the screen (to display tool-tips, for example). But <a rel="nofollow" href="https://powerbi.microsoft.com/en-us/blog/interactive-r-custom-visuals-support-is-here/" target="_blank">in the latest update</a> to Power BI, you can create <a rel="nofollow" href="https://github.com/Microsoft/PowerBI-visuals#building-r-powered-custom-visual-corrplot" title="" target="_blank">create R custom visuals</a> that embed interactive R charts, like this:</p>
<p><a rel="nofollow" href="https://powerbi.microsoft.com/en-us/blog/interactive-r-custom-visuals-support-is-here/" target="_blank"><img src="https://i0.wp.com/powerbicdn.azureedge.net/mediahandler/blog/media/PowerBI/blog/ad83fa59-749e-47b4-80bd-e622981113de.gif?w=450&ssl=1" data-recalc-dims="1"></a></p>
<p>The above chart was created with the <a rel="nofollow" href="https://plot.ly/r/" target="_blank">plotly package</a>, but you can also use <a rel="nofollow" href="http://gallery.htmlwidgets.org/" target="_blank">htmlwidgets</a> or any other R package that creates interactive graphics. The only restriction is that the output must be HTML, which can then be embedded into the Power BI dashboard or report. You can also publish reports including these interactive charts to the <a rel="nofollow" href="https://powerbi.microsoft.com/en-us/documentation/powerbi-service-get-started/" target="_blank">online Power BI service</a> to share with others. (In this case though, you're restricted to those <a rel="nofollow" href="https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-packages-support/#r-scripts-that-are-not-supported-in-power-bi" target="_blank">R packages supported in Power BI online</a>.)</p>
<p>Power BI now provides four custom interactive R charts, <a rel="nofollow" href="https://github.com/microsoft/PowerBI-visuals-spline" target="_blank">available as add-ins</a>:</p>
<ul>
<li><a rel="nofollow" href="https://store.office.com/en-us/app.aspx?assetid=WA104380816&ui=en-US&rs=en-US&ad=US&appredirect=false" target="_blank">Time-series forecasting using the forecast package</a>, with interactive range selection, data selection and tooltips (<a rel="nofollow" href="https://github.com/microsoft/PowerBI-visuals-forcasting-exp" target="_blank">code</a>)</li>
<li><a rel="nofollow" href="https://store.office.com/en-us/app.aspx?assetid=WA104380888&ui=en-US&rs=en-US&ad=US&appredirect=false" target="_blank">Time-series forecasting using the arima package</a>, with data selection and tooltips (<a rel="nofollow" href="https://github.com/Microsoft/powerbi-visuals-forcastingarima" target="_blank">code</a>)</li>
<li><a rel="nofollow" href="https://store.office.com/en-us/app.aspx?assetid=WA104380861&ui=en-US&rs=en-US&ad=US&appredirect=false" target="_blank">K-means clustering</a>, with data selection and tooltips (<a rel="nofollow" href="https://github.com/microsoft/PowerBI-visuals-clustering-kmeans" target="_blank">code</a>)</li>
<li><a rel="nofollow" href="https://store.office.com/en-us/app.aspx?assetid=WA104380860&ui=en-US&rs=en-US&ad=US&appredirect=false" target="_blank">Spline smoothing charts</a>, with data selection and tooltips (<a rel="nofollow" href="https://github.com/microsoft/PowerBI-visuals-spline" target="_blank">code</a>)</li>
</ul>
<p>You can also create your own custom R visuals. The documentation explains how to create <a rel="nofollow" href="https://github.com/Microsoft/PowerBI-visuals/blob/master/RVisualTutorial/CreateRHTML.md" target="_blank">custom R visuals from HTML output</a>, and you can also use the code on Github for the provided visuals linked above as a guide. For more on the new custom visuals, take a look at the blog post linked below.</p>
<p>Microsoft Power BI Blog: <a rel="nofollow" href="https://powerbi.microsoft.com/en-us/blog/interactive-r-custom-visuals-support-is-here/" target="_blank">Interactive R custom visuals support is here!</a></p>
</div>
	<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2017/06/interactive-r-visuals-in-power-bi.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a rel="nofollow" href="https://www.r-project.org/" title="The R Project for Statistical Computing">R</a> news and <a rel="nofollow" href="https://www.r-bloggers.com/search/tutorial" title="R tutorials">tutorials</a> on topics such as: <a rel="nofollow" href="https://www.r-bloggers.com/search/data%20science" title="Data science">Data science</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data" title="Big Data">Big Data, <a rel="nofollow" href="https://www.r-users.com/" title="R jobs">R jobs</a>, visualization (<a rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2" title="ggplot and ggplot2 tutorials">ggplot2</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/boxplot" title="Boxplots using lattice and ggplot2 tutorials">Boxplots</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/map" title="Maps and gis">maps</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/animation" title="Animation in R">animation</a>), programming (<a rel="nofollow" href="https://www.r-bloggers.com/search/RStudio" title="RStudio IDE for R">RStudio</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/sweave" title="Sweave and literate programming">Sweave</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX" title="LaTeX in R">LaTeX</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/SQL" title="SQL and databases">SQL</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/eclipse" title="Eclipse IDE for R">Eclipse</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/git" title="git and github, Version Control System">git</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/hadoop" title="Large data in R using Hadoop">hadoop</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping" title="Web Scraping of google, facebook, yahoo, twitter and more using R">Web Scraping</a>) statistics (<a rel="nofollow" href="https://www.r-bloggers.com/search/regression" title="Regressions and ANOVA analysis tutorials">regression</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/PCA" title="principal component analysis tutorial">PCA</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/time+series" title="Time series">time series</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/trading" title="finance trading">trading</a>) and more...
<img width="1" alt="" src="http://feeds.feedburner.com/~r/RBloggers/~4/qBJFeonTw2Q" height="1"></a></div>