Dynamic Measure Required with two slicer
Hi Folks, I'm trying to develop the dashboard by comparing two months and their uses of two slicers. I prepared the dashboard using Excel Formulas. please help to develop Power-BI As the Raw data is attached Excel is available. please refer it Google Drive Link for Excel File Please feel free to contact for more info if required. RAW Data Period Account Value X Value Y Value Z Fix Tata 4 3 5 Fix Birla 6 7 8 Fix Adani 7 8 9 Fix RIL 8 9 10 Fix Tata 9 10 11 Fix Birla 10 11 12 Jan Adani 11 12 13 Jan RIL 12 13 14 Jan Tata 13 14 15 Jan Birla 14 15 16 Jan Adani 15 16 17 Feb RIL 16 17 18 Feb Tata 17 18 19 Feb Birla 18 19 20 Feb Adani 19 20 21 Feb RIL 20 21 22 March Tata 21 22 23 March Birla 22 23 24 March Adani 23 24 25 March RIL 24 25 26 March Tata 25 26 27 March Birla 26 27 28 March Adani 27 28 29 April RIL 28 29 30 April Tata 29 30 31 April Birla 30 31 32 April Adani 31 32 33 April RIL 32 33 34 April Tata 33 34 35 Regards, MOHIT
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)COMPARTILHAR
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 precisoBar 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.1
Forecasting 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)
