How to filter/show top 10 values Or how we can change the top 10 rows background.

[Anonymous]

I have set of data which is having multiple rows. I have populated in table view to visualize. I want to show/filter/differntiate only top 10 rows based on Column2 (Desc order).  

Here is the sample data

Any help is appreciated.

Thanks

SK

[Anonymous]

@PaulDBrown  Yeah it worked. thanks !!

[Anonymous]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

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

[PaulDBrown]

In the filter pane, select column1, select TOP N in the filter options, add the measure to the field value and type in 10 in the Top N value

[Anonymous]

@PaulDBrown I dont see any option for Top N for Column2.

[PaulDBrown · Accepted solution]

The Top N option will be under column1. You will need a measure for column2 though. Probably 
Sum column2 = SUM(Table[Column2])

Once you've selected the filter option for Top N, add the measure to the filter and type in 10 for the Top N