Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Box and Whisker Chart setting: 1.5IQR and Inclusive/Exclusive

  Hi   I'm trying to plot my data and identify outliers. Here's my data. I have three industries as categories, and one metric. I want to identify outliers in each industry. I created a Sampling I...
Need Help
Show and Tell
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

    You can refer to this article: Power BI Box and Whisker chart.

    Quartile calculation:
    1. Inclusive - When calculation the 1st and 3rd quartile, the median is included in the calculation. Equivalent of the Excel calculation QUARTILE.INC()
    2. Exclusive - When calculation the 1st and 3rd quartile, the median is excluded in the calculation. Equivalent of the Excel calculation QUARTILE.EXC()

     

    Whisker Type:
    1. Min/Max - The whiskers represent the minimum and maximum values of the dataset.
    2. < 1.5 IQR - The top and bottom whiskers are set to the highest/lowest value of the dataset that are included in the 1.5IQR range.
    3. = 1.5IQR - The top and bottom whiskers are set to 1.5IQR of the dataset.
    4. Custom - The whiskers can be set to a custom percentile value based on the dataset. The lower value is bound to the lower percentile possible and 25%. And the same is for the higher value, but then from 75% and up to the highest percentile value possible.

     

    Best Regards,
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

You can refer to this article: Power BI Box and Whisker chart.

Quartile calculation:
1. Inclusive - When calculation the 1st and 3rd quartile, the median is included in the calculation. Equivalent of the Excel calculation QUARTILE.INC()
2. Exclusive - When calculation the 1st and 3rd quartile, the median is excluded in the calculation. Equivalent of the Excel calculation QUARTILE.EXC()

 

Whisker Type:
1. Min/Max - The whiskers represent the minimum and maximum values of the dataset.
2. < 1.5 IQR - The top and bottom whiskers are set to the highest/lowest value of the dataset that are included in the 1.5IQR range.
3. = 1.5IQR - The top and bottom whiskers are set to 1.5IQR of the dataset.
4. Custom - The whiskers can be set to a custom percentile value based on the dataset. The lower value is bound to the lower percentile possible and 25%. And the same is for the higher value, but then from 75% and up to the highest percentile value possible.

 

Best Regards,
Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.