Forum Discussion

NINO's avatar
NINO
New Member
8 years ago

Box and Whisker chart/Quartile

Hello,   I have a super simple dataset (just 12 integers with rows for category and sampling) that I am using for box and whisker chart visual. The same dataset I used in excel and got different re...
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi NINO,

 

QUARTILE() use three points that divide a set of values into four equal groups, each group comprising a quarter of the data. However, there's no such function in power bi, as a workaround, i would recommend you to use PERCENTILE.INC or PERCENTILE.EXC to achieve your requirement. A similar case for your reference: https://community.powerbi.com/t5/Desktop/How-do-you-slice-data-into-quartiles-and-quintiles/td-p/157262.

 

Regards,

Jimmy Tao

NINO's avatar
NINO
New Member
8 years ago

Hello Jimmy,

 

Thank you very much for your reply.

I am having problems with the Box and Whisker Chart visual that should calculate quartiles for summarizing data. However, I am not getting right results. I am just interested what is the proper use of this particular visual.

 

Thanks again!

 

Cheers,

 

Nino

 

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi NINO,

     

    "I am having problems with the Box and Whisker Chart visual that should calculate quartiles for summarizing data. However, I am not getting right results. I am just interested what is the proper use of this particular visual."

     

    <-- Could you give more details about your expected requirement?

     

    Regards,

    Jimmy Tao