<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/power-bi-custom-visuals-based-on-r/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2016/12/power-bi-custom-visuals-based-on-r.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p>You've been able to include <a target="_blank" rel="nofollow" href="https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-visuals/">user-defined charts using R in Power BI dashboards</a> for a while now, but a recent update to <a target="_blank" rel="nofollow" href="https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-powered-custom-visuals/">Power BI includes seven new custom charts based on R</a> in the customs visuals gallery. You can see the new chart types by visiting the <a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/">Power BI Custom Visuals Gallery</a> and clicking on the &quot;R-powered visuals&quot; tab.</p>
<p><a target="_blank" rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01bb096510cb970d-pi"><img title="Visuals library" alt="Visuals library" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01bb096510cb970d-800wi" border="0"></a></p>
<p>The new custom visuals are listed below. Click on the visual names to see an example, and click on the &quot;GitHub&quot; link at the bottom of the pop-up to see the actual R code used.</p>
<ul>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_8EDDC07B_EE79_4418_A84C_D73897C0E21F">Clustering</a>, based on the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/NbClust/">NbClust package</a></li>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_967A08ED_59CD_405F_B41A_8CE2050AD30E">Clustering with Outliers</a>, based on the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/dbscan/">dbscan package</a></li>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_FC22EF20_6A7C_4F30_B29B_144CD82E5279">Correlation Plot</a>, based on the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/corrplot/">corrplot package</a></li>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_807533A8_7DBB_41E8_AF46_0450D3447E61">Decision Tree</a>, based on the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/rpart/">rpart</a> and the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/rpart.plot/">rpart.plot</a> packages</li>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_8EDDC07B_EE79_4418_A84C_D73897C0E21F">Forecasting</a>, based on the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/forecast/">forecast</a> package</li>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_3EEA6E26_A754_4ECA_BE51_C93859851FB2">Association Rules</a>, based on the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/arules/">arules</a> and <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/arulesViz/">arulesViz</a> packages</li>
<li><a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/PBI_CV_3DFBB0D1_6AFB_4242_B6E1_7116023B1167">Smoothing Splines</a>, based on the <a target="_blank" rel="nofollow" href="https://www.rdocumentation.org/packages/splines/versions/3.3.2">splines</a> package</li>
</ul>
<p>You can also combine custom R charts with other Power BI tools to create <em>interactive</em> R charts. A favorite of mine is the <a target="_blank" rel="nofollow" href="https://app.powerbi.com/visuals/show/Timeline1447991079100">Timeline slicer</a>, which allows you to select a range from a date variable. (The dashboard, including the R charts, is updated using only data from the date range you select.) You can also use the built-in date slicer for similar effect, and Tomaž Kaštrun demonstrates how to combine it with a custom R chart in his blog post <em><a target="_blank" rel="nofollow" href="https://tomaztsql.wordpress.com/2016/12/18/r-graphs-and-tables-in-power-bi-desktop/">R graphs and Tables in Power BI Desktop</a></em>.</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/2016/12/power-bi-custom-visuals-based-on-r.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 title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/AftafTBLfTU"></a></div>