r in power query
14 Topics- 22KViews2likes0Comments
Não remover linhas duplicadas no Power BI usando R e deixar eixos dos histogramas invisíveis
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)7KViews0likes0CommentsCOMPARTILHAR
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 preciso12KViews0likes0CommentsBar Chart with Error Bars
Description This is a chart that was built to show pricing of various products. The data set contains many different prices for each product. Therefore the bar is the average price and the error bars (whiskers) are portraying the one standard deviation away from the mean. Learn It The following tutorial uses the same R script shown here. You can find more interesting power BI tutorials at www.powerbi.tips Prerequisites (The sample .pbix files won't work without installing the following) 1. Install R Engine Power BI does not include the R engine. Therefore, a seperate installation is required to install R on your local computer. You can download R from the Revolution Open download page, and through the CRAN Repository. 2. Install the R packages Once R engine has been installed you can dowload the package from the Revolution Open Package Downloads Page. Required R Packages ggplot2 Tested on MRO 3.3.1, CRAN 3.3.1Solved43KViews7likes4CommentsForecasting in R Visual / R Custom Visual / Power Query / Line Chart
Many faces of forecasting ... Attached sample contains 4 fifferent ways to perform forecasting with exponential smoothing algorithm. 1) Using R-powered Custom Visual 2) Using R-visual 3) Using R-in-Power Query (data transform with R) 4) Using new "forecasting" option in good old Line Chart Do not forget to install required R packages The R code inside Power Query step is also attached (and also accessible in PBIX)14KViews0likes3CommentsClustering using k-mean in power query, elbow chart
In this demo files I cluster my fitibit data, I have shown how to: 1.write R codes inside the power query to cluster data using k-mean algorithm 2. show the result using powerBI features (tab 1 and 2) 3.identify the best number of cluster via "elbow"chart (tab 3) for more explanaton visit below blog http://radacad.com/clustering-concepts-writing-r-codes-inside-power-bi-part-5 http://radacad.com/k-mean-clustering-in-r-writing-r-codes-inside-power-bi-part-6 for download the file if you downloadthe zip file simply extract it for pbxi file, you should download it, you will see the download as zip file , then change the file type to pbxi, I am following the problem with portal manager to see how to download easily eyJrIjoiZjYyOWFmM2EtM2IxOS00OTA3LWIyOGQtM2YzMTk3MWI1YWNkIiwidCI6ImNjODBmOGQ2LTNjMzUtNGRhNC1iMGY4LWNiZWFkYjAwNDY3ZSIsImMiOjEwfQ16KViews2likes0Comments