Forum Discussion
Can Power BI Visualize Significance Testing in a Table form?
Hi all,
I am working on gathering some info on using R and Power BI together and was wondering if it was possible to visualize significance testing in a table format?
Here is a dummy table of what we would like to recreate in the Power BI environment where columns of data are tested against each other across the rows and letters are used to indicate statistically significant differences column to column.
| OUTPUT | ||||
| A | B | C | D | E |
| 45%CD | 44%CD | 32% | 33% | 41%cd |
| 52%Bd | 35% | 65%ABDE | 43%b | 52%Bd |
| 63%Ce | 75%ACDE | 43% | 62%C | 55%C |
| 43% | 76%ACDE | 56%AD | 43% | 52%ad |
| 61% | 65%C | 54% | 58% | 61% |
Anyone know if this is possible?
Thanks,
Chris
Currently there are two main things we can do with R Script in Power BI:
- Run R scripts directly in Power BI Desktop, and import the resulting datasets into a Power BI Desktop data model.
- Use R scripts to create Power BI visuals, and use them to visualize your data in Power BI.
So we can both visualize R data using Power BI visuals and use R created visuals to visualize data in Power BI. In this scenario, I think it is possible for you to visualize significance testing in a table format as you mentioned above.
Regards
6 Replies
Hi, you cannot reuse your dataframes in powerbi to use the powerbi visuals, R in powerbi is just to see R visuals, in my case, I'm using R on Spark and and the end I create a HiveTable to be consumed in my PowerBI.
Regards
Hi John,
Thanks for the response and sorry if this seems like a dumb question but as I am not well versed in R, can your response be summed up as:
If it can be visualized using R it can be shown in Power BI using the R visuals, but not routed through the Power BI visuals.
I have colleagues that work with R regularly, I just want to get them the correct information before I ask them to do any work.
Thanks,
Chris
Currently there are two main things we can do with R Script in Power BI:
- Run R scripts directly in Power BI Desktop, and import the resulting datasets into a Power BI Desktop data model.
- Use R scripts to create Power BI visuals, and use them to visualize your data in Power BI.
So we can both visualize R data using Power BI visuals and use R created visuals to visualize data in Power BI. In this scenario, I think it is possible for you to visualize significance testing in a table format as you mentioned above.
Regards
