R Script Showcase topics

How do I uncover this

Denyz — Mon, 19 Aug 2024 17:41:22 GMT

Motion Chart and 3D Cube in PowerBI

boosalis — Sat, 15 Aug 2026 14:00:07 GMT

Select between the visuals using the select boxes at the top of the screen.

I always wanted to be able to have a decent motion chart and draggable 3D cube in Power BI.

Select between the visuals using the select boxes at the top of the screen.

I tried to use code from the packages that render these visualizations using MS R and Power BI, but my efforts were unsuccessful.

What did work was using the HTML visualizer from the PBI Marketplace. I exported the HTML from the R Studio for the motion cart and the cube, and then dropped the files into webspace. Once I added the URLs to the visualizer in PBI and published it to the web, I finally got what I wanted.

Yeah, it’s quite a bit of a hack, but I’m happy anyway.

Note that you can rotate the cube, select items on the legend, and push the play button on the motion chart.

eyJrIjoiMTAyOGYwYzctZTNiOC00YWIyLTkwOWItNTZkOTU4Yjg5NTBiIiwidCI6ImI2YjQ5MDAxLThiM2YtNDNmYS05OWExLTcwNmU4YzdlMzU5OCIsImMiOjZ9

South of France Restaurant Concentration - Choropleth Map

Anonymous — Mon, 04 Jul 2022 11:19:55 GMT

Não remover linhas duplicadas no Power BI usando R e deixar eixos dos histogramas invisíveis

Anonymous — Tue, 07 Dec 2021 18:26:02 GMT

Olá a todos!

Gostaria de saber se usando hist() existe alguma maneira de deixar os eixos invisíveis e se no power bi tem uma forma de fazê-lo não remover as linhas com valores duplicados

Segue abaixo código feito até agora

# O código a seguir para criar um dataframe e remover as linhas duplicadas sempre é executado e age como um preâmbulo para o script:

# dataset <- data.frame(Granulometria)

# dataset <- unique(dataset)

# Cole ou digite aqui seu código de script:

bp=hist(dataset$Granulometria,

breaks = c(45,47,49,51,53,55),

main="",xlab="", ylab="",

col = c("pink"),

border = FALSE,

xlim = c(45,55),

labels = FALSE)

text(x=bp$mids, y=bp$counts, labels=bp$counts ,cex=2,pos=1)

descriptive statistics in R / Power Bi

Anonymous — Tue, 28 Sep 2021 20:11:49 GMT

Hello, this is my first submision.

I'd like some opinions. 🙂

Slicer bar change chemical element using DAX, Selected Value

Histogram , box plot and table is an R scrip

trend is Powerbi chart

greetings

Connecting Wikidata to Power BI using R

DataKnowledge — Tue, 10 Aug 2021 19:32:39 GMT

Description

Provides the ability to run a query written for Wikidata and create a dataset from the output for import into Power BI.

Example

Taking Wikidata relating to the location of where ships were wrecked off the coast of Scotland UK and plotting these locations on a map provided by esri which shows oil & gas licencing blocks on the UK Continental Shelf. This provides an example of how easy it can be to combine two different resources into one map.

Note: This report has been created purely to demonstrate how datasets from distinct providers can be combined on a map. The accuracy of the underlying data has not been checked by the report owner. Also note that the locations are where the ships were wrecked, it does not mean that the ships are still there today.

Prerequisite

R required to be installed on local computer along with required R package.
In Power BI ensure 'R scripting' is set up in 'Options'

Required R package

WikidataQueryServiceR

R code used in example

Disclaimers:

The pbix file attached contains third party data and third party resources. Their terms of service and licensing requirements should be respected and compiled with.

Pauline Cairns

Anonymous — Sun, 11 Apr 2021 05:22:34 GMT

Olá,

Pessoal,

Quero compartilhar meu painel na web mas a conta pede um administrador... E mesmo seguindo toooodos os vídeos do youtube, não consegui compartilhar meu painel...

O que preciso é compartilhar apenas a visualização e filtro de forma que não seja necessário login e senha....

Alguém tem um caminho fácil???

ou até incorporar em alguma plataforma que tenha a funcionalidade que preciso

Matrix Bubble Chart

Anonymous — Tue, 23 Feb 2021 14:35:36 GMT

What

A powerful Power BI R visual, matrix bubble chart, to analyze three measures (facts) with two selected dimensions.

How

One needs to have R installed on the computer or to the server / enabled in the cloud environment.

Here is a guide to get started: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
Here is a link to some details: https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

Analysis example

The edge color of a bubble tells about the margin % of a product.
The fill color of a bubble tells about the % of opportunities won (hitrate) of a product.
The bubble size illustrates the number of the opportunities.
In the X-axis is the product dimension.
In the Y-axis is the free feature bundle given together with the product dimension.

This could be an example from the car industry. The question could be what bundles we want to offer with what products and how should we price the product & bundle combinations.

See my blog post for an example use case:

https://www.plainlyresults.com/blog/power-bi-r-matrix-bubble-chart-sales-opportunity-analysis/

CODE

Add in your Power BI R visual the code below the "Paste or type your script code here:" text.

#change lib path to were you have ggplot2 and scales installed
library(ggplot2, lib="D:/Program Files/R/R-3.6.3/library")
require(ggplot2)
library(scales, lib="D:/Program Files/R/R-3.6.3/library")

#change columns Product, Free_feature_bundle, dataset$... to your columns in the Power BI model selected to the R visual
ggplot(dataset, aes(x = Product, y = Free_feature_bundle, label = paste(round(dataset$Opportunity_count, digits=0), round(dataset$Hitrate_perc, digits=2)*100, round(dataset$Margin_perc, digits=2)*100, sep=";"))) +
geom_point(shape = 21, aes(size = round(dataset$Opportunity_count, digits=0) , fill = round(dataset$Hitrate_perc, digits=2)*100, color = round(dataset$Margin_perc, digits=2)*100, stroke = 3)) +
geom_text(hjust = 1, size = 4) +
scale_size(range = c(15,50)) + #scaling of the bubbles
theme_bw()+ scale_fill_gradient2("Hitrate % (fill)", low=muted("red"), high=muted("green"), midpoint =
mean(dataset$Hitrate_perc*100)) +theme_bw()+ scale_color_gradient2("Margin % (edges)", low=muted("red"),
high=muted("green"), midpoint = mean(dataset$Margin_perc*100)) + labs(size = "Number of opportunities (size)")

R multiple visual in one: Regression Table and Boxplot

Quentin — Wed, 05 Feb 2025 10:29:35 GMT

In this pbix File, we construct an analysis of Theory of change and create a R visual that gather a regression analysis and a Boxplot visual.

Theory of change is a theoritical relation between indicators:

Gestion -> Output -> Outcome -> Impact

How we do -> What we do -> Why we do -> General Objective

Topic and Sentiment Analysis Chart

SidMacherla — Sat, 22 Aug 2020 21:57:27 GMT

Author: Sidharth Macherla

Documentation + Source Code + Usage guide + Submit bugs + License are available at foyi digital library

R Packages needed:
library(tm)
library(topicmodels)
library(vader)

library(ggplot2)

Tested on:

Windows 10, 64 Bit machine with R 3.5.3

Dot Plot Chart with line (gantt)

DavisBI — Tue, 21 Jul 2020 01:42:21 GMT

ABOUT

This chart is used to better show the flow of tasks, and facilitate the collaboration of different teams and the arrangement of tasks. Also, it has more uses, such as can be used as a historical chronology (as below)

The source code has been attached, or you can click here to get it and modify the parameters to customize the format of your chart.

REQUIRED R PACKAGES

ggplot2

TEST ON

R (Version 4.0.2 64-bit);

Power BI Desktop(2020-June 64-bit );

Power BI Service (Pro License Required)

LEGAL DISCLAIMERS

Terms of Service

Process Mining with the bupaR library

Michael_Mertens — Sat, 20 Jun 2020 14:44:16 GMT

Hi everyone,

I created a little project that approaches the topic of Process Mining and uses the R library bupaR (https://www.bupar.net/).
Some explanations can be found here in my blog: https://www.mmertens.eu/2020/06/process-mining-with-power-bi-and-r-visuals/

I used date from a competion at the ICMP Process Mining Conference: https://icpmconference.org/2019/icpm-2019/contests-challenges/bpi-challenge-2019/

The PBIX is attached, also a "standalone" R-Script for testing. And here is the link to the github repository: https://github.com/michael-mertens/Power-BI-R-Process-Mining

Finally, when I entered the subject, I was pointed to a very good blog post with the same topic that I hadn't seen before (because I searched only the "R Script Showcase" forum): https://community.powerbi.com/t5/Community-Blog/Business-Process-Analysis-in-PowerBI-using-R-visuals/ba-p/659401 from LeiQian .

Her explanations seem to be more detailed but the example is not attached.

Regards
Michael

Sparklines in power bi Column under the Matrix visual

v-nesaw — Wed, 06 May 2020 21:06:25 GMT

I have a dataset where I need the sparklines besides the % nos which is shown in the image.

Basically under metric visual I want the sparkline to be besides the value under that column.

SIMPLE K-CHART (Candlestick)

DavisBI — Tue, 07 Apr 2020 17:09:06 GMT

ABOUT

A simple k-chart generated by basic R.

FEATURE

Ability to control R visualization using DAX
(such as switching colors, showing or hiding charts, changing calculation behavior, etc.)

REQUIRED R PACKAGES

None

TEST ON

Power BI Desktop(2.79.5768.721 64-bit ); Power BI Services (Pro License Required)

LEGAL DISCLAIMERS

Terms of Service

Inverted Y Axis with Constants

RyanBentham — Wed, 17 Apr 2019 10:03:19 GMT

Objective of Visual

- To flip the Y Axis so that values with a larger Y Value are closer to the X Axis rather than the traditional line chart that shows Zero at the X Axis intersection

- Allow the addition of 2 constant dotted line values that can be linked to a measure or parameter.

CRAN Packages used

- ggplot2

- scales

- extrafontdb

www.rviz.co.uk

Quantifying Operational Risk - Frequency Distribution Fitting

Anonymous — Tue, 26 Feb 2019 11:12:14 GMT

How to fit different curves to observed frequency loss

Quantifying Operational Risk - Frequency Analysis

Anonymous — Thu, 21 Feb 2019 11:05:21 GMT

How to analyse frequency of events

Quantifying Operational Risk Exposure and Capital Requirements

R packages

almartinezos — Fri, 25 Jan 2019 21:10:19 GMT

Hi. The R package smooth is very useful to forecast time series with mobile average model. Is there a way to introduce it? The bug onlie appear when i publish an app.

Machine Learning + Score Calibration with R and Power BI

Anonymous — Wed, 12 Sep 2018 07:42:45 GMT

How to build machine learning for credit scoring and calibrating into scorecard

eyJrIjoiMjVhZjBlOGEtMWNhMS00NWIxLTliMmItYzI2NDkzNjI1YzhiIiwidCI6IjA1NzQ0MzkyLWIzMDktNDc1YS1hZGY2LWYzNDFhYmRiMzFkNSJ9

Machine Learning + Model Evaluation

Anonymous — Mon, 10 Sep 2018 10:39:36 GMT

Develop and evaluate popular machine learning models inside Power BI using R

R Script Showcase topics

How do I uncover this

Motion Chart and 3D Cube in PowerBI

South of France Restaurant Concentration - Choropleth Map

Não remover linhas duplicadas no Power BI usando R e deixar eixos dos histogramas invisíveis

descriptive statistics in R / Power Bi

Connecting Wikidata to Power BI using R

COMPARTILHAR

Matrix Bubble Chart

What

How

Analysis example

CODE

R multiple visual in one: Regression Table and Boxplot

Topic and Sentiment Analysis Chart

Dot Plot Chart with line (gantt)

ABOUT

REQUIRED R PACKAGES

TEST ON

LEGAL DISCLAIMERS

Process Mining with the bupaR library

Sparklines in power bi Column under the Matrix visual

SIMPLE K-CHART (Candlestick)

ABOUT

FEATURE

REQUIRED R PACKAGES

TEST ON

LEGAL DISCLAIMERS

Inverted Y Axis with Constants

Quantifying Operational Risk - Frequency Distribution Fitting

Quantifying Operational Risk - Frequency Analysis

R packages

Machine Learning + Score Calibration with R and Power BI

Machine Learning + Model Evaluation