Skip to main content

Power BI

New

Allow field aggregation by percentile

Vote (17) 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

eaaf9219 cc4e-4bfe-9679-a730a7062e9b 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

d5efdb2b 9bda-47f2-b20d-84ada6419e67 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

dfa9382f fa0e-4d1a-9d9a-a9c12994595c 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