Forum Discussion

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...

Helper II

9 years ago

HI,

Thank you for giving reply.

I am trying to Create Conditional color in grid using below code.but I am getting small error.that is "could not find function "%>%"" Please help me out .how to resolve it.

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

Helper II

9 years ago

HI,

I have tried in R Language.It is working fine.But I need in Power bi Desktop with R.

I have tried with same code in Power bi Desktop.

It is Coming error like "error: could not find function "%>%" pipe"

PLease help me out.