do a top 10 on a table visual?

Hi Anonymous ,

According to your statement, I think there are two questions in your post. One is how to use Top N in table visual and another is how to show managers in “other” group which are out of Top N range.

1. As other users mention you can use Top N function in filter field. Use Top N and add [Hour] measure into By value field.

2. "Other" group and managers should be legend in pie chart. So I suggest you to create a calculated column.

New Legend = 
VAR _RANK = RANKX(Project,[Hour],,DESC,Dense)
RETURN 
IF(_RANK <=10, Project[Manager],"Other")

In my Sample, I show Top 3.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.