R-Density Plot (Histrogram) for a Power BI Performance Baseline

Posted On April 27, 2018

install.packages(“ggplot2”)

install.packages(“scales”)

just drag the duration column of your dataset to the R-Chart Control in Power BI and add the following code into your R-Control:

library(“ggplot2”)

library(“scales”)

ggplot(dataset)+

geom_histogram(binwidth=500,aes(x = duration/1000, y = ..ncount..)) +

scale_y_continuous(labels = percent_format())

you can also try changing the binwidth and filter out very fast queries with a power BI filter.