Forum Discussion

shreyyyyy's avatar
shreyyyyy
Frequent Visitor
9 years ago

Percentile chart : Best way?

Hi   There was percentile chart available in Power BI earlier: https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-percentile-chart/   But this was removed for IDK reasons. Now ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi shreyyyyy,

 

I got below result referring to Simon-Hou's suggestion in above link. Does this meet your desired output?

 

If not, what is your expected result? Coud you post an image to illustrate? Also, what do you mean 'I dont know how to create a loop and store values so that I can run it on any data set and plot the graph.'?

 

Regards,
Yuliana Gu

shreyyyyy's avatar
shreyyyyy
Frequent Visitor
9 years ago

Hey,

Thanks for the prompt response.

 

A spike can never come in a percentile chart, since for percentile calculation, the data is always sorted.

Also, it looks from first view that you have calculated the percentiles for each data point and then plotted it. Whereas, I am looking for a graph exactly similar to this:

https://www.youtube.com/watch?v=SwZh7jz_tgI&t=338s

 

So that I can see P50, P80 etc values for any data set.