Ranking one column of data

[dentonblake]

Hello-

I'm new the community and Power BI.

Have a fairly simple question:  I have a table with about 1,800,000 rows and would like to display the top 100 based on a 'Total Receipts" column.  Any suggestions are greatly appreciated!  -db

[v-shex-msft · Accepted solution]

Hi @dentonblake,

You can achieve this requirement by setting visual level fiter.

Setps:
1. Create the table visual.
2. Switch the index column to filter mode to 'top n', drag value column 'Total Receipts' as the sorting column.

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Share some data and show your expected result.