{"id":956,"date":"2023-01-06T15:41:19","date_gmt":"2023-01-06T15:41:19","guid":{"rendered":"https:\/\/monocroft.com\/?p=956"},"modified":"2023-01-08T19:38:23","modified_gmt":"2023-01-08T19:38:23","slug":"how-to-get-the-top-n-items-in-a-power-bi-matrix-table","status":"publish","type":"post","link":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/","title":{"rendered":"How to Get the Top N Items in a Power BI Matrix Table"},"content":{"rendered":"\n

Generally, filtering the Top “N” items is a common requirement in business reporting as it is easily understandable. In this article, I will explain a step-by-step method on how to get the Top “N” items using a Power BI matrix table. <\/p>\n\n\n\n

Let’s get started.<\/p>\n\n\n\n

Introduction<\/h2>\n\n\n\n

To get started, make sure you have your dataset inserted into Power BI Desktop. In the Fields panes, select the tables you want to work with and select Matrix Table<\/strong><\/em> in the Visualization<\/em><\/strong> pane.<\/p>\n\n\n\n

In this example, I used State and sorted by Sales. So, I have a table of sales from every state in the dataset<\/em>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Filter the Top “N” Items<\/h2>\n\n\n\n

Now, I want to filter the top “N” sales in the data. “N” here will be 10<\/em>. That means I will be filtering the top 10 Sales by States<\/em><\/strong> in the data. <\/p>\n\n\n\n

To do this, I will make use of the Filters<\/em> <\/strong>pane.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

On the Filters<\/strong> pane, you will notice there are two values on the Filters on the visual<\/em><\/strong> which are Sales and State.<\/strong><\/em> Since I will be filtering by states, I will click on State<\/em><\/strong>, and select Filter by N<\/strong><\/em> under Filter type.<\/strong><\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

In Show items<\/strong><\/em>, make sure it is on Top<\/em><\/strong> (because you are working with the top N value)<\/em>. Now, type the number of “N” <\/em>values you want to work with in the box. Don’t forget the “N” value I am working with is 10 for this tutorial.<\/em><\/p>\n\n\n\n

After typing the number of “N” values<\/em>, the next thing to do is to drag the value you want to filter it with. <\/p>\n\n\n\n

Since I am looking for the sales value of the top 10 states<\/em>, I will drag Sales<\/strong><\/em> into By value<\/em><\/strong> and click on Apply filter<\/em><\/strong>.<\/p>\n\n\n\n

\"how<\/figure>\n\n\n\n

Automatically, this process will change the table on the canvas to display the top<\/em> 10 sales by States<\/em><\/strong>.<\/p>\n\n\n\n

\"how<\/figure>\n\n\n\n

Conclusion: How to Get the Top N Items in a Power BI Matrix Table<\/h2>\n\n\n\n

Keep in mind that these steps will only affect the display of the matrix table or any other form of visualization you are working with, and will not modify the underlying data in any way. <\/p>\n\n\n\n

However, if you want to filter the data itself, you will need to use a different method, such as creating a DAX measure or using a slicer.<\/p>\n\n\n\n

I hope you understand these steps. <\/p>\n\n\n\n

Thanks for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"

Generally, filtering the Top “N” items is a common requirement in business reporting as it is easily understandable. In this … <\/p>\n

Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1057,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"yoast_head":"\nHow to Get the Top N Items in a Power BI Matrix Table - Monocroft<\/title>\n<meta name=\"description\" content=\"The article explains a step-by-step approach on how to get the Top N Items in a Power BI Matrix Table. Read to learn more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Get the Top N Items in a Power BI Matrix Table - Monocroft\" \/>\n<meta property=\"og:description\" content=\"The article explains a step-by-step approach on how to get the Top N Items in a Power BI Matrix Table. Read to learn more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Monocroft\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-06T15:41:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-08T19:38:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Matt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\"},\"author\":{\"name\":\"Matt\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\"},\"headline\":\"How to Get the Top N Items in a Power BI Matrix Table\",\"datePublished\":\"2023-01-06T15:41:19+00:00\",\"dateModified\":\"2023-01-08T19:38:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\"},\"wordCount\":400,\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg\",\"articleSection\":[\"Guides\",\"PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\",\"url\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\",\"name\":\"How to Get the Top N Items in a Power BI Matrix Table - Monocroft\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg\",\"datePublished\":\"2023-01-06T15:41:19+00:00\",\"dateModified\":\"2023-01-08T19:38:23+00:00\",\"description\":\"The article explains a step-by-step approach on how to get the Top N Items in a Power BI Matrix Table. Read to learn more.\",\"breadcrumb\":{\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg\",\"width\":720,\"height\":405,\"caption\":\"how to get the top n items in a power bi matrix table - monocroft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/monocroft.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Get the Top N Items in a Power BI Matrix Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/monocroft.com\/#website\",\"url\":\"https:\/\/monocroft.com\/\",\"name\":\"Monocroft\",\"description\":\"Monocroft Tech\",\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/monocroft.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/monocroft.com\/#organization\",\"name\":\"Triburge\",\"url\":\"https:\/\/monocroft.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"width\":512,\"height\":512,\"caption\":\"Triburge\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\",\"name\":\"Matt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"caption\":\"Matt\"},\"url\":\"https:\/\/monocroft.com\/author\/matthew\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Get the Top N Items in a Power BI Matrix Table - Monocroft","description":"The article explains a step-by-step approach on how to get the Top N Items in a Power BI Matrix Table. Read to learn more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/","og_locale":"en_US","og_type":"article","og_title":"How to Get the Top N Items in a Power BI Matrix Table - Monocroft","og_description":"The article explains a step-by-step approach on how to get the Top N Items in a Power BI Matrix Table. Read to learn more.","og_url":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/","og_site_name":"Monocroft","article_published_time":"2023-01-06T15:41:19+00:00","article_modified_time":"2023-01-08T19:38:23+00:00","og_image":[{"width":720,"height":405,"url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg","type":"image\/jpeg"}],"author":"Matt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Matt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#article","isPartOf":{"@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/"},"author":{"name":"Matt","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3"},"headline":"How to Get the Top N Items in a Power BI Matrix Table","datePublished":"2023-01-06T15:41:19+00:00","dateModified":"2023-01-08T19:38:23+00:00","mainEntityOfPage":{"@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/"},"wordCount":400,"publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"image":{"@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg","articleSection":["Guides","PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/","url":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/","name":"How to Get the Top N Items in a Power BI Matrix Table - Monocroft","isPartOf":{"@id":"https:\/\/monocroft.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage"},"image":{"@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg","datePublished":"2023-01-06T15:41:19+00:00","dateModified":"2023-01-08T19:38:23+00:00","description":"The article explains a step-by-step approach on how to get the Top N Items in a Power BI Matrix Table. Read to learn more.","breadcrumb":{"@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#primaryimage","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/01\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table-monocroft.jpg","width":720,"height":405,"caption":"how to get the top n items in a power bi matrix table - monocroft"},{"@type":"BreadcrumbList","@id":"https:\/\/monocroft.com\/how-to-get-the-top-n-items-in-a-power-bi-matrix-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/monocroft.com\/"},{"@type":"ListItem","position":2,"name":"How to Get the Top N Items in a Power BI Matrix Table"}]},{"@type":"WebSite","@id":"https:\/\/monocroft.com\/#website","url":"https:\/\/monocroft.com\/","name":"Monocroft","description":"Monocroft Tech","publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/monocroft.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/monocroft.com\/#organization","name":"Triburge","url":"https:\/\/monocroft.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","width":512,"height":512,"caption":"Triburge"},"image":{"@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3","name":"Matt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","caption":"Matt"},"url":"https:\/\/monocroft.com\/author\/matthew\/"}]}},"_links":{"self":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/956"}],"collection":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/comments?post=956"}],"version-history":[{"count":64,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/956\/revisions"}],"predecessor-version":[{"id":1090,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/956\/revisions\/1090"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media\/1057"}],"wp:attachment":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media?parent=956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/categories?post=956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/tags?post=956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}