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êsJoin us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
180 | |
96 | |
79 | |
77 | |
74 |