Forum Discussion

indu's avatar
indu
Helper II
9 years ago

power bi Table Visuilation in R

Hi,   I want to display Conditional color Formatting in table with more than 3  colors and disable sorting icon in Table Chart. So We donot have solution in current power bi.That is the reason I P...
Need Help
indu's avatar
indu
Helper II
9 years ago

Yes Right I am Using Rstudio only.

I have added below line.But Still I am getting error.

library("magrittr")

COuld you please help me the correct code in Power Bi with R.

 

PLease find below code which I have Use In Power bi.

 

options(DT.options = list(pageLength = 5))
df = as.data.frame(cbind(matrix(round(rnorm(50), 3), 10), sample(0:1, 10, TRUE)))
library("magrittr")
# style V6 based on values of V6
datatable(df) %>% formatStyle(
'V6',
backgroundColor = styleEqual(c(0, 1), c('gray', 'yellow'))
)

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

there is bad news,

  • the minor thing, you also have to reference the library DT using library("DT")
  • the major thing, the function datatable returns an HTML widget, currently the R script visual inside Power BI just supports objects of typ plots, this means that you currently can't achieve what you are looking for using the DT approach, unless you are willing to create a Custom R visual (no it's some same as the R script visual, you can start here: https://github.com/Microsoft/PowerBI-visuals/tree/master/RVisualTutorial)

Maybe you have to rethink, and give the function tableGrob from the gridExtra a try. Additional information is available here:

https://cran.r-project.org/web/packages/gridExtra/vignettes/tableGrob.html

 

This is what I'm using :-)

 

Regards

 

Regards