Inter quartile range

[Kumar11109]

Hello all, for a given set of time spent by groups I need to calculate quartiles so that I can find the outliers. Can somebody help me with this.?

[v-ljerr-msft · Accepted solution]

Hi @Kumar11109,

You can try the custom visual Box and Whisker chart which is a convenient way of graphically depicting groups of numerical data through their quartiles in Power BI. 

Regards

[Kumar11109]

I want to create a box plot, that's why I want to calculate the iqr.

[v-ljerr-msft · Accepted solution]

Hi @Kumar11109,

You can try the custom visual Box and Whisker chart which is a convenient way of graphically depicting groups of numerical data through their quartiles in Power BI. 

Regards

[Kumar11109 · Accepted solution]

This worked. Thank You for your help. 

[Kumar11109]

Hi @v-ljerr-msft,
I tried the box and whisker chart, but what fields do I need to fill out in sampling and category. In my data, I have viewing time for each session. I need to create box and whisker chart for the same. I am attaching a sample of the data set.

Thank You, 

Kumar Ashwarya 

[Kumar11109]

Hello @v-ljerr-msft

I will work on it and get back to you?? Hopefully, this would solve my purpose.

Thank You,

Kumar Ashwarya