Hello-
Can someone please show me how to create percentile groupings in PowerBI that can be adjusted based on filters I apply? See below image for reference. I manually Pivoted out Items and Invoice Sales to group the percentiles but I need this to be able to be done automatically. For instance, when I filter to a Category, I would like to see:
Rows: Top Ten Percent (by Sales), Next 20%, Next 20%, Next 20%, and Bottom 10%
Values: Count of Items, Sales, etc
Keep in mind, I want the percentile groupings to be variable. If I filter to Category X, I would like to know how many items make up the Top Ten % of that Category.
Thanks in advance!
