Motion Chart and 3D Cube in PowerBI
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. eyJrIjoiMTAyOGYwYzctZTNiOC00YWIyLTkwOWItNTZkOTU4Yjg5NTBiIiwidCI6ImI2YjQ5MDAxLThiM2YtNDNmYS05OWExLTcwNmU4YzdlMzU5OCIsImMiOjZ9Process Mining with the bupaR library
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
Matrix Bubble Chart
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)")
Dumbbell Chart by MAQ Software
Dumbbell Chart helps users analyze changes in critical data. This visual is an excellent choice for illustrating the change between two data points and comparing the distances between them. Dumbbell Chart gets its name thanks to its resemblance to a gym weight. The visual consists of a dual-axis combination chart, where one axis is marked by a circle and the other is marked by a line that spans data points provided by the user. Key features include: · The ability to display the performance of multiple indicators. · The ability to compare the growth or loss of indicators across various categories. · Easy interaction with many data points using the zoom functionality. · Quick downloading of an image of the chart with the capture image widget. R package dependencies (auto installed): plotly and ggplot2SIMPLE K-CHART (Candlestick)
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 ServiceCOMPARTILHAR
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
