Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 |
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português