Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

do a top 10 on a table visual?

I have a typical model, with my Project and Fact dimensions.   In my visual I am showing: ‘Project’[Manager] and a Hours measure from the Fact.   The visual works fine:   But it shows hun...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

     

sandeephijam's avatar
sandeephijam
Icon for Helper II rankHelper II
3 years ago

Have you tried  adding the filter option on the Power BI. I think this option might be able to give you the solution you are looking for. In here you can select the "Top N" and provide show Items as Top 10

 

 

Hope this help