{"id":691,"date":"2024-06-05T08:00:46","date_gmt":"2024-06-05T06:00:46","guid":{"rendered":"https:\/\/www.syntera.ch\/blog\/?p=691"},"modified":"2024-07-18T15:22:57","modified_gmt":"2024-07-18T13:22:57","slug":"top-n-filter-on-multiple-dimensions-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/","title":{"rendered":"Top N filter on multiple dimensions in Power BI"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-f56f613f wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-post-author has-medium-font-size\"><div class=\"wp-block-post-author__avatar\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=48&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&#038;d=mm&#038;r=g 2x' class='avatar avatar-48 photo' height='48' width='48' \/><\/div><div class=\"wp-block-post-author__content\"><p class=\"wp-block-post-author__byline\">LEAD BUSINESS INTELLIGENCE<\/p><p class=\"wp-block-post-author__name\">Dimitri B\u00fctikofer<\/p><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-outermost-social-sharing alignright has-small-icon-size has-icon-color is-style-logos-only is-content-justification-left is-layout-flex wp-container-outermost-social-sharing-is-layout-fa5e4718 wp-block-outermost-social-sharing-is-layout-flex\"><li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-linkedin has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2024%2F06%2F05%2Ftop-n-filter-on-multiple-dimensions-in-power-bi%2F&#038;title=Top%20N%20filter%20on%20multiple%20dimensions%20in%20Power%20BI\" aria-label=\"Share on LinkedIn\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M19.7,3H4.3C3.582,3,3,3.582,3,4.3v15.4C3,20.418,3.582,21,4.3,21h15.4c0.718,0,1.3-0.582,1.3-1.3V4.3 C21,3.582,20.418,3,19.7,3z M8.339,18.338H5.667v-8.59h2.672V18.338z M7.004,8.574c-0.857,0-1.549-0.694-1.549-1.548 c0-0.855,0.691-1.548,1.549-1.548c0.854,0,1.547,0.694,1.547,1.548C8.551,7.881,7.858,8.574,7.004,8.574z M18.339,18.338h-2.669 v-4.177c0-0.996-0.017-2.278-1.387-2.278c-1.389,0-1.601,1.086-1.601,2.206v4.249h-2.667v-8.59h2.559v1.174h0.037 c0.356-0.675,1.227-1.387,2.526-1.387c2.703,0,3.203,1.779,3.203,4.092V18.338z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on LinkedIn\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-mail has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"mailto:?subject=Top%20N%20filter%20on%20multiple%20dimensions%20in%20Power%20BI&#038;body=Top%20N%20filter%20on%20multiple%20dimensions%20in%20Power%20BI%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2024%2F06%2F05%2Ftop-n-filter-on-multiple-dimensions-in-power-bi%2F\" aria-label=\"Email this Page\"  class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M20,4H4C2.895,4,2,4.895,2,6v12c0,1.105,0.895,2,2,2h16c1.105,0,2-0.895,2-2V6C22,4.895,21.105,4,20,4z M20,8.236l-8,4.882 L4,8.236V6h16V8.236z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tEmail this Page\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-whatsapp has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/api.whatsapp.com\/send?text=Top%20N%20filter%20on%20multiple%20dimensions%20in%20Power%20BI%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2024%2F06%2F05%2Ftop-n-filter-on-multiple-dimensions-in-power-bi%2F\" aria-label=\"Share on WhatsApp\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M 12.011719 2 C 6.5057187 2 2.0234844 6.478375 2.0214844 11.984375 C 2.0204844 13.744375 2.4814687 15.462563 3.3554688 16.976562 L 2 22 L 7.2324219 20.763672 C 8.6914219 21.559672 10.333859 21.977516 12.005859 21.978516 L 12.009766 21.978516 C 17.514766 21.978516 21.995047 17.499141 21.998047 11.994141 C 22.000047 9.3251406 20.962172 6.8157344 19.076172 4.9277344 C 17.190172 3.0407344 14.683719 2.001 12.011719 2 z M 12.009766 4 C 14.145766 4.001 16.153109 4.8337969 17.662109 6.3417969 C 19.171109 7.8517969 20.000047 9.8581875 19.998047 11.992188 C 19.996047 16.396187 16.413812 19.978516 12.007812 19.978516 C 10.674812 19.977516 9.3544062 19.642812 8.1914062 19.007812 L 7.5175781 18.640625 L 6.7734375 18.816406 L 4.8046875 19.28125 L 5.2851562 17.496094 L 5.5019531 16.695312 L 5.0878906 15.976562 C 4.3898906 14.768562 4.0204844 13.387375 4.0214844 11.984375 C 4.0234844 7.582375 7.6067656 4 12.009766 4 z M 8.4765625 7.375 C 8.3095625 7.375 8.0395469 7.4375 7.8105469 7.6875 C 7.5815469 7.9365 6.9355469 8.5395781 6.9355469 9.7675781 C 6.9355469 10.995578 7.8300781 12.182609 7.9550781 12.349609 C 8.0790781 12.515609 9.68175 15.115234 12.21875 16.115234 C 14.32675 16.946234 14.754891 16.782234 15.212891 16.740234 C 15.670891 16.699234 16.690438 16.137687 16.898438 15.554688 C 17.106437 14.971687 17.106922 14.470187 17.044922 14.367188 C 16.982922 14.263188 16.816406 14.201172 16.566406 14.076172 C 16.317406 13.951172 15.090328 13.348625 14.861328 13.265625 C 14.632328 13.182625 14.464828 13.140625 14.298828 13.390625 C 14.132828 13.640625 13.655766 14.201187 13.509766 14.367188 C 13.363766 14.534188 13.21875 14.556641 12.96875 14.431641 C 12.71875 14.305641 11.914938 14.041406 10.960938 13.191406 C 10.218937 12.530406 9.7182656 11.714844 9.5722656 11.464844 C 9.4272656 11.215844 9.5585938 11.079078 9.6835938 10.955078 C 9.7955938 10.843078 9.9316406 10.663578 10.056641 10.517578 C 10.180641 10.371578 10.223641 10.267562 10.306641 10.101562 C 10.389641 9.9355625 10.347156 9.7890625 10.285156 9.6640625 C 10.223156 9.5390625 9.737625 8.3065 9.515625 7.8125 C 9.328625 7.3975 9.131125 7.3878594 8.953125 7.3808594 C 8.808125 7.3748594 8.6425625 7.375 8.4765625 7.375 z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on WhatsApp\t\t<\/span>\n\t<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI makes it fairly easy to implement top N filters on your visuals using the filter pane. You can quickly add the dimension you want to apply the top N filter to, select the number of items to display, and choose the column or measure for the calculation. However, what if you need to calculate a top N by multiple dimensions instead of just one? For instance, instead of showing the top 5 products by sales, you might want to display the top 5 products for each region and\/or for each year by sales. Or perhaps you&#8217;ve already used a top N filter for a specific workaround, such as implementing a single date picker as we discussed in a <a href=\"https:\/\/www.syntera.ch\/blog\/2024\/04\/03\/single-date-picker-in-power-bi\/\">previous blog<\/a>, and now you need an additional top N statement for your analysis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is it as simple as adding another Top N filter to the filter pane? Unfortunately, it\u2019s not. Power BI will display an error message stating that &#8220;A top N filter is already applied.&#8221; So, how can we implement multiple top N filters or a top N filter using multiple dimensions?<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Problem<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s focus on the goal of displaying the best-selling product by region and year. By utilizing the Top N filter from the filter pane, we can identify the best-selling product:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1012\" height=\"556\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/01_Single_TopN-2.png\" alt=\"\" class=\"wp-image-696\" style=\"width:700px\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/01_Single_TopN-2.png 1012w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/01_Single_TopN-2-300x165.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/01_Single_TopN-2-768x422.png 768w\" sizes=\"auto, (max-width: 1012px) 100vw, 1012px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">However, if we add country and year to the table, something unexpected happens. We only see one entry per region and year, which might suggest that the top N filter worked. But in reality, the best-selling product was calculated beforehand, and only this product is displayed for each combination of country and year. You&#8217;ll notice that the product remains the same for each row:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/02_Single_TopN_issue-2-1024x577.png\" alt=\"\" class=\"wp-image-697\" style=\"width:700px\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/02_Single_TopN_issue-2-1024x577.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/02_Single_TopN_issue-2-300x169.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/02_Single_TopN_issue-2-768x433.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/02_Single_TopN_issue-2.png 1075w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Solution<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">To resolve this issue, we need to create a measure using the RANKX() function, which will assign a rank to each row in our table. Our goal is to generate a new ranking (starting from 1) for every combination of region and year. The measure to achieve this looks like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>RANK Sales by product region year = \nRANKX(\n    ALLSELECTED(Sales&#91;Product]),\n    &#91;Sales],\n    ,\n    DESC,\n    Skip\n)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The <code>ALLSELECTED()<\/code> function removes any filters applied to the <code>Sales[Product]<\/code> column while preserving filters on other columns. This allows us to respect the filters from the year and region columns for a given row while opening up the filter context for the product column to calculate the rank. We can add the measure to the table to see the results:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"837\" height=\"667\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/03_Table_with_Rank-1.png\" alt=\"\" class=\"wp-image-699\" style=\"width:700px\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/03_Table_with_Rank-1.png 837w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/03_Table_with_Rank-1-300x239.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/03_Table_with_Rank-1-768x612.png 768w\" sizes=\"auto, (max-width: 837px) 100vw, 837px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Notice that after the combination of France, 2019, the ranking starts from one again. By utilizing this new Rank column in our table, we can now use the filter pane to display only the rows with a rank of 1:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"633\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1-1024x633.png\" alt=\"\" class=\"wp-image-700\" style=\"width:700px\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1-1024x633.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1-300x185.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1-768x474.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1.png 1099w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Using the same logic, we can display the top 3 products (or any other number) for each year and region by simply changing the filter to &#8220;Rank is less than or equal to 3&#8221;. If you prefer not to display the rank in your table, you can remove the column, the filter from the filter panel will be sufficient to narrow down your table to the desired rows.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">More about Power BI:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/04\/03\/single-date-picker-in-power-bi\/\">Single Date Picker in Power BI<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/05\/14\/login-to-power-bi-with-guest-account\/\">Login to Power BI with Guest Account<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/03\/19\/automated-power-bi-testing-with-selenium\/\">Automated Power BI Testing with Selenium<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/01\/16\/analyse-bexio-data-with-power-bi\/\">Analyse bexio Data with Power BI &#8211; Syntera<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Power BI makes it fairly easy to implement top N filters on your visuals using the filter pane. You can quickly add the dimension you want to apply the top N filter to, select the number of items to display, and choose the column or measure for the calculation. However, what if you need to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":700,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[6],"class_list":["post-691","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","tag-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Top N filter on multiple dimensions in Power BI - Syntera<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top N filter on multiple dimensions in Power BI - Syntera\" \/>\n<meta property=\"og:description\" content=\"Power BI makes it fairly easy to implement top N filters on your visuals using the filter pane. You can quickly add the dimension you want to apply the top N filter to, select the number of items to display, and choose the column or measure for the calculation. However, what if you need to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Syntera\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-05T06:00:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-18T13:22:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1099\" \/>\n\t<meta property=\"og:image:height\" content=\"679\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dimitri B\u00fctikofer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dimitri B\u00fctikofer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/\",\"url\":\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/\",\"name\":\"Top N filter on multiple dimensions in Power BI - Syntera\",\"isPartOf\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\"},\"datePublished\":\"2024-06-05T06:00:46+00:00\",\"dateModified\":\"2024-07-18T13:22:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.syntera.ch\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Top N filter on multiple dimensions in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\",\"url\":\"https:\/\/www.syntera.ch\/blog\/\",\"name\":\"Syntera\",\"description\":\"translating data into business value.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034\",\"name\":\"Dimitri B\u00fctikofer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g\",\"caption\":\"Dimitri B\u00fctikofer\"},\"sameAs\":[\"http:\/\/www.syntera.ch\"],\"url\":\"https:\/\/www.syntera.ch\/blog\/author\/dimitri\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Top N filter on multiple dimensions in Power BI - Syntera","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:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Top N filter on multiple dimensions in Power BI - Syntera","og_description":"Power BI makes it fairly easy to implement top N filters on your visuals using the filter pane. You can quickly add the dimension you want to apply the top N filter to, select the number of items to display, and choose the column or measure for the calculation. However, what if you need to [&hellip;]","og_url":"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/","og_site_name":"Syntera","article_published_time":"2024-06-05T06:00:46+00:00","article_modified_time":"2024-07-18T13:22:57+00:00","og_image":[{"width":1099,"height":679,"url":"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2024\/06\/04_Table_Rank1.png","type":"image\/png"}],"author":"Dimitri B\u00fctikofer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dimitri B\u00fctikofer","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/","url":"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/","name":"Top N filter on multiple dimensions in Power BI - Syntera","isPartOf":{"@id":"https:\/\/www.syntera.ch\/blog\/#website"},"datePublished":"2024-06-05T06:00:46+00:00","dateModified":"2024-07-18T13:22:57+00:00","author":{"@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034"},"breadcrumb":{"@id":"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.syntera.ch\/blog\/2024\/06\/05\/top-n-filter-on-multiple-dimensions-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.syntera.ch\/blog\/"},{"@type":"ListItem","position":2,"name":"Top N filter on multiple dimensions in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.syntera.ch\/blog\/#website","url":"https:\/\/www.syntera.ch\/blog\/","name":"Syntera","description":"translating data into business value.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034","name":"Dimitri B\u00fctikofer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g","caption":"Dimitri B\u00fctikofer"},"sameAs":["http:\/\/www.syntera.ch"],"url":"https:\/\/www.syntera.ch\/blog\/author\/dimitri\/"}]}},"_links":{"self":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/comments?post=691"}],"version-history":[{"count":5,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/691\/revisions"}],"predecessor-version":[{"id":707,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/691\/revisions\/707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media\/700"}],"wp:attachment":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media?parent=691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/categories?post=691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/tags?post=691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}