return the first 10 rows of a sorted column

[dw700d]

I have a table with 54 employees. The table is sorted by the cogs split column. I would like to find a way to list the first 10 sorted employees in a table. And then list the next ten (11-20) sorted employees in a separate table. And the next 10 (21-30) in a separate table and the next ten (31-40) in a separate table and the next ten (41-50) in a separate table and the remaining 4 in a separate table. Any thoughts on how I can accomplish this?

Full Name	cogs split	Position
Bob	["Bob"]	SVP
Amy	["Bob","Amy"]	VP
Ken	["Bob","Amy","Ken"]	AVP
Cole	["Bob","Amy","Ken","Cole"]	Director
Kim	["Bob","Amy","Ken","Cole","Kim"]	Assistant Director
Al	["Bob","Amy","Ken","Cole","Kim","Al"]	Analyst

[MFelix · Accepted solution]

Hi @dw700d ,

If you have the table sorted on Power Query by the cogs split, just add an index column on the power query and then use that column to filter out that index on the visualization accordingly to your needs.

https://support.microsoft.com/en-us/office/add-an-index-column-power-query-dc582eaf-e757-4b39-98e6-b...