Running chi square test in Power BI and displaying the results on Power BI dashboard!

[kdesai]

Hi, 

I have created the data queries already by connecting Power BI to SQL server.

I want to run chi square test on this data to understand if the differences between two sets of data are significant.

Also want to display these results in a compelling way, so that its easier for the audience to understand.

Has anyone worked on such use case??

Any inputs are appreciated!!

[v-juanli-msft]

Hi @kdesai

a possible method is to utilize R and Power BI Desktop to visualize significance testing.

For more details using R in Power BI Desktop, please review the following articles.

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

Chi-Square Test in R with Example

Best Regards

maggie

[Greg_Deckler]

This looks like a very interesting problem. Can we assume that your data looks something along the line of:

Observed

ID,Category1,Category2,Category3

1,224,303,230

2,223,300,250

Expected

ID,Category1,Category2,Category3

1,225,305,235

2,225,305,235

Or? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[kdesai]

Hi,

Yes, My data is in the above format.

Here is a screen shot!