R Visual Control Question

[espo4life]

I have an R visual that displays this

here is the R script I am using

#dataset <- data.frame(TheDate)
#dataset <- unique(dataset)
require(RODBC)

z <- nrow(dataset)
x <- dataset[z,1]
y <- dataset[1,1]

require(RODBC)
library(gridExtra)
library(dplyr)
library(ggplot2)

ch <- odbcDriverConnect(".....)

resultset = sqlQuery(ch, paste0("SELECT * FROM [dbo].[fnCUSTCLUBPLAN] ('",y,"','",x,"')"))
colnames(resultset)
colnames(resultset) <- sapply(colnames(resultset) , function(x) paste(strwrap(x, width = 15), collapse="\n"))
qplot(x=1:5, y=1:5, geom = "blank") + theme(line = element_blank(), text = element_blank()) + 
annotation_custom(grob=tableGrob(resultset, rows=NULL))

close(ch)

My questions are:

1. Can I control how big the visual is rentered and resize the whole area without resizing the table?

2. Can I do some better formatting (like heading backgrounds, etc)?

[v-yingjl · Accepted solution]

Hi @espo4life ,

You can refer these issues and articles that hope to help you:

1. R plotly custom visualization margin padding 
2. R Visual with transparent background 
3. How to create R custom visual (html) in PowerBI 
4. A Guide to Using R with Power BI 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.