Creating Table 1 for baseline characteristics in power BI

[tyankama]

Hello,

While creating Table 1 for baseline characteristics (figure below) in R is very easy using table1 or tableone packages, doing so in power bi has been a real struggle for me.

So far I've followed this approach  

1. imported my data via SQL into power bi

2. run R script to create table 1 as a data frame in Edit Queries > Transform

3. displayed the new data (as in figure, 4 columns, 9 rows) in power BI 

Given the lack of "table 1" add-in, this process works for me. However, I am unable to add in a time slicer and allow the descriptive statistics in my table to change because the date/time columns are not in my new data set.

So I'd like to ask the following questions

1. is there other efficient way I can produce table 1 in power bi?

2. how can I add in the time slicer so that the numbers in table 1 change accordingly?

Thanks!

Tuyen  

[v-yuta-msft]

@tyankama ,

So your issue is you can't see the added column in power bi table, right? This issue should be related to your R script, could you share some R script for further test? Also please refer to doc below:
https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

https://docs.microsoft.com/en-us/power-bi/desktop-r-scripts

Community Support Team _ Jimmy Tao

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

[tyankama]

Hello adding a column & R script are not my issues. My issue is to how to turn raw data into table 1 (similar to the figure above) and be able to add a time slicer so that the descriptive statistics in my table change accordingly.