The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
On my personal device I have R and RStudio installed. I then opened Power BI Desktop and enabled R scripting (so that I could embed an R visual into the report). Power BI automatically detected that I have R installed.
I then typed the following R code into my R visual in Power BI:
library(plotly) Animals <- c("giraffes", "orangutans", "monkeys") SF_Zoo <- c(20, 14, 23) LA_Zoo <- c(12, 18, 29) data <- data.frame(Animals, SF_Zoo, LA_Zoo) fig <- plot_ly(data, x = ~Animals, y = ~SF_Zoo, type = 'bar', name = 'SF Zoo') fig <- fig %>% add_trace(y = ~LA_Zoo, name = 'LA Zoo') fig <- fig %>% layout(yaxis = list(title = 'Count'), barmode = 'group') fig
But it keeps saying 'Can't display this visual':
You can take a look at this blog post. It describes how to add an interactive javascript Plotly Chart in Power BI. It's quite easy.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!