How to plot percentile wise values in Power BI?

[jaysgovindiya]

Description: We want to plot percentile wise values in line chart in Power BI for larger set of data currently we have used below formula to calculate Percentile Rank 

Percentile = (No of value below Max Number/ Total No of values ) * 100

Issue: Not able to generate output for larger amount of data due to in sufficient memory. We need similar functionality like PERCENTRANK.INC formula of excel in Power BI.

Chart Values:
X-axis : Percentile values between 0 to 100
Y-axis:  Actual value or Average value

Let me know if any one has optimium approach for same use case.

Thanks

[jaysgovindiya]

Hello @v-stephen-msft 
Thanks for providing support for thread, I need Percentile Rank thing like if we have one column for values
i. e. 1,3,3,4,4,7,7,8,9,10 then we need output like what is the value for 95th percentile? so based on percentile we need graph for same.

[v-stephen-msft]

Hi @jaysgovindiya ,

You could try show value as percent of grand total.

Or you can display the percentage by dividing by 100 and clicking the "%" button.

Best Regards,

Stephen Tao

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