Skip to main content

Power BI

Needs Votes

Allow field aggregation by percentile

Vote (19) Share
Dinh Doan Van Bien's profile image

Dinh Doan Van Bien on 06 Jul 2016 22:20:02

Currently it's quite easy to aggregate fields by count, mean, median. Can you add top percentile as an aggregate?

Comments (3)
Dinh Doan Van Bien's profile image Profile Picture

Chris Smith on 05 Jul 2020 23:32:51

RE: Allow field aggregation by percentile

Any update on this "idea"? I mean, I know the logic to calculate the percentiles is there because I can drop a %ile line on a graph. I would really love to put the same data into a table automatically.

Dinh Doan Van Bien's profile image Profile Picture

Michael on 05 Jul 2020 22:42:59

RE: Allow field aggregation by percentile

I would love this. It could even be part of the TOPN filter (top 25%).

Dinh Doan Van Bien's profile image Profile Picture

Bharat Kumar on 05 Jul 2020 22:37:31

RE: Allow field aggregation by percentile

Many a times we need to show the data for like 95th percentile or 99th percentile. This is a big miss currently in PowerBI