topic Re: Power BI Quartile Analysis in Developer

Power BI Quartile Analysis

cyborgandy — Wed, 01 Jun 2022 14:54:49 GMT

Hi All,

I have below data set with more than 500 rows I want to add quartile wise disturbutation as per NPS score like A, B,C,D which we do in excel, is it possible to do it on power bi.

Advisor Number	Advisor Name	Count of NPS Advisor	Sum of NPS %
XXXX	XXXXXXXXXXXX	18	22%
XXXX	XXXXXXXXXXXX	23	48%
XXXX	XXXXXXXXXXXX	32	9%
XXXX	XXXXXXXXXXXX	21	14%
XXXX	XXXXXXXXXXXX	18	6%
XXXX	XXXXXXXXXXXX	37	43%
XXXX	XXXXXXXXXXXX	18	56%
XXXX	XXXXXXXXXXXX	21	24%
XXXX	XXXXXXXXXXXX	32	31%
XXXX	XXXXXXXXXXXX	19	42%
XXXX	XXXXXXXXXXXX	21	33%

Re: Power BI Quartile Analysis

v-chenwuz-msft — Mon, 06 Jun 2022 07:13:06 GMT

Hi cyborgandy ,

Not quite sure what you mean by A,B,C,D in your excel. Can you give some example data and explain how to calculate quartile?

Or you can use PERCENTILE.INC(<column>, 0.25) to do that in power bi.

Best Regards

Community Support Team _ chenwu zhu

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

Re: Power BI Quartile Analysis

cyborgandy — Tue, 07 Jun 2022 15:56:01 GMT

Yes I am looking for the same outcome like .75 Top Quartile, 0.50 Medium Quartile,0.25 Bottom Quartile

Re: Power BI Quartile Analysis

v-chenwuz-msft — Wed, 08 Jun 2022 07:10:01 GMT

Hi cyborgandy ,

Please try this code:

0.25 Bottom Quartile = PERCENTILE.INC('Table'[Sum of NPS %],0.25)

If you need more help, please share your pbix without sensitive data and expect result.

Best Regards

Community Support Team _ chenwu zhu

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