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
Go to Solution.
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.
View solution in original post
Share some data and show your expected result.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!