Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to create a report for top 5 and bottom 5 performers where under the heading series we have a number of different episodes and these have different playcounts, watch minutes, minutes per play and unique users. So for each series which are the top performing episodes have to be displayed.If I use filter type Top N by WT minutes on the Episodes but that approach I know is not correct in order to get top 5 performers for each Series. Please help. Tha above excel file example is just to give a format for the table structure,
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |