Forum Discussion

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago
Solved

Inter quartile range

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.?
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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. :smileyhappy:

     

    App image

     

    Regards

  • Kumar11109's avatar
    Kumar11109
    9 years ago

    This worked. Thank You for your help. 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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. :smileyhappy:

 

App image

 

Regards

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago

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