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. 

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago
I want to create a box plot, that's why I want to calculate the iqr.
  • 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

      Hello v-ljerr-msft

       

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

       

      Thank You,

       

      Kumar Ashwarya 

       

       

    • 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 

       

    • Kumar11109's avatar
      Kumar11109
      Helper IV
      9 years ago

      This worked. Thank You for your help.