{"id":11217,"date":"2022-04-27T08:52:27","date_gmt":"2022-04-27T08:52:27","guid":{"rendered":"https:\/\/viewmyprojects.com\/winwirewp\/?p=11217"},"modified":"2023-11-29T04:29:13","modified_gmt":"2023-11-29T04:29:13","slug":"filters-in-power-bi","status":"publish","type":"post","link":"https:\/\/viewmyprojects.com\/winwirewp\/blog\/filters-in-power-bi\/","title":{"rendered":"How to Disable Values in Filter Pane for Filters in Power BI Report"},"content":{"rendered":"\n<p>Power BI provides offers rich visual that interacts well with the other visuals that are included on a Power BI report. However, one of the main complaints has been that the slices use up very precious screen real estate, especially when you are trying to add in data visuals onto a report.<\/p>\n\n\n\n<p>Filters were previously available in Power BI, but Microsoft has upgraded the functionality of filters within <a href=\"https:\/\/viewmyprojects.com\/winwirewp\/blog\/embracing-the-power-of-power-bi-the-factory-model-approach\/\">Power BI<\/a>. Through this blog you can quickly learn how you can disable values in filter pane in a Power BI and how you can leverage it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Filters in Power BI Report<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Disable Aggregated Values in Filter Pane<\/h3>\n\n\n\n<ol style=\"list-style-type:1\" class=\"blog-detail-list wp-block-list\">\n<li>Some of your customers might come up with unique requirement, where they want to disable values in filters which are appearing Filter Pane. Like the below screenshot, it reflects the before and after results.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-14-3.webp\" alt=\"Filters in Power BI\" class=\"wp-image-11218\"\/><\/figure><\/div>\n\n\n<p class=\"blog-detail-list\">    2. With simple clicks you can do these changes in report at Power BI desktop or Services<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Desktop Version<\/h3>\n\n\n\n<p>     3. How to make changes in Power BI desktop<\/p>\n\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Open the PBIX or Power BI file, which you want to make changes in the report<\/li>\n\n\n\n<li>Screenshot of my PBIX file before making changes<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-15-3.webp\" alt=\"Filters in Power BI\" class=\"wp-image-11219\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>If you are using updated version of Power BI desktop, then you will see the External tools option in Menu Bar, below screenshot for your reference<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-16-3.webp\" alt=\"Filters in Power BI\" class=\"wp-image-11220\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Now do a single click on \u201cTabular Editor\u201d Icon in External Tools<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"76\" height=\"135\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/image-17.png\" alt=\"\" class=\"wp-image-11221\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>After a click, you will see \u201cTabular Editor\u201d UI on your screen (usually it will take 10 seconds to option this UI)<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-18-1.webp\" alt=\"Filter Pane in power bi\" class=\"wp-image-11222\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Select Model and go to Options-&gt;Discourage Implicit Measures<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-19-1.webp\" alt=\"Filter Pane in power bi\" class=\"wp-image-11223\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Change False to True<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-20-1.webp\" alt=\"Filter Pane in power bi\" class=\"wp-image-11225\"\/><\/figure><\/div>\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-21-2.webp\" alt=\"Understand Power BI Filters\" class=\"wp-image-11226\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Below screenshot after changes<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-22-1.webp\" alt=\"Understand Power BI Filters\" class=\"wp-image-11227\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Power BI Service Version<\/h3>\n\n\n\n<p class=\"blog-detail-list\">      4. &nbsp;How to make changes in Power BI Services<\/p>\n\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>To do this activity, we need Tabular Editor Application or Software installed in our laptop or desktop\n<ul class=\"wp-block-list\">\n<li>First, let\u2019s see how to install Tabular Editor Application or Software in our laptop or desktop\n<ul class=\"wp-block-list\">\n<li>Download the Tabular Editor from this <a href=\"https:\/\/tabulareditor.com\/downloads\" target=\"_blank\" rel=\"noopener\">link<\/a><\/li>\n\n\n\n<li>You can see the Installation process in this <a href=\"https:\/\/docs.tabulareditor.com\/te3\/getting-started.html\" target=\"_blank\" rel=\"noopener\">link<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Once you installed Tabular Editor in your laptop or desktop, you will see the Tabular Editor Application in Windows Menu, or you can find in Windows Search Box by typing Tabular Editor<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-23-1.webp\" alt=\"Understand Power BI Filters\" class=\"wp-image-11228\"\/><\/figure><\/div>\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-24-1.webp\" alt=\"types of filters in power BI\" class=\"wp-image-11229\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Open Tabular Editor (Currently I am using trail version with my official email address)<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-25-1.webp\" alt=\"types of filters in power BI\" class=\"wp-image-11230\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Go to Power BI services and Open the Workspace in which you want to make changes<\/li>\n\n\n\n<li>Please note that Workspace in which you want to make changes it should have <strong>Premium Per User <\/strong>or<strong> Premium Per Capacity <\/strong>or<strong> Embedded <\/strong>Capacity or Licensed<\/li>\n\n\n\n<li>Once you open the Workspace in Power Bi services then click on settings<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-26-1.webp\" alt=\"types of filters in power BI\" class=\"wp-image-11231\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>As of now I am using Premium per user trial version<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-27-1.webp\" alt=\"report level filters in power BI\" class=\"wp-image-11232\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Click on Copy option<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-28-1.webp\" alt=\"report level filters in power BI\" class=\"wp-image-11233\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Go to Tabular Editor Application-&gt;Click on below highlighted option in Tabular Editor<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-29-1.webp\" alt=\"report level filters in power BI\" class=\"wp-image-11234\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Paste the copied URL in Server<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-30-1.webp\" alt=\"report level filters in power BI\" class=\"wp-image-11235\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Click on Integrated or Give User and Password &#8211; When you click on Integrated option, it will take you through the Microsoft application for email address and password, please follow those steps<\/li>\n\n\n\n<li>Once you are done above step, you will see the below screenshot, in which you will see all the list of reports in select workspace, as of now I have only one report in this workspace<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-31-1.webp\" alt=\"\" class=\"wp-image-11236\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Click on OK<\/li>\n\n\n\n<li>Click on Model -&gt;Go Properties-&gt;Options-&gt; Discourage Implicit Measures<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-32-1.webp\" alt=\"\" class=\"wp-image-11237\"\/><\/figure><\/div>\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Change from False to True<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-33-1.webp\" alt=\"\" class=\"wp-image-11239\"\/><\/figure><\/div>\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-34-1.webp\" alt=\"\" class=\"wp-image-11240\"\/><\/figure><\/div>\n\n\n<p><\/p>\n\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Do Ctrl+S on your keyboard to save changes<\/li>\n\n\n\n<li>Below screenshot shows before and after results from Power BI services of the report<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/image-35-1.webp\" alt=\"\" class=\"wp-image-11241\"\/><\/figure><\/div>\n\n\n<p>Advantage of making \u201cDiscourage Implicit Measure\u201d as True, it will improve the performance of Power BI report by using only Explicit Measures<\/p>\n\n\n\n<p>Disadvantage of this activity is that user will not be able to convert implicit measure (fields from table\u2019s) as aggregated value like First, Last, Count, Count (Distinct), Sum, Maximum, Minimum, Average, Variance, Mean and Standard Deviation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h3>\n\n\n\n<p>The new filter pane functional provides a rich alternative to Power BI slicers while at the same time limits the amount of report real estate required for the filtering process. Hope this blog will help you to solve the unique problem.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power BI provides offers rich visual that interacts well with the other visuals that are included on a Power BI report. However, one of the main complaints has been that the slices use up very precious screen real estate, especially when you are trying to add in data visuals onto a report. Filters were previously&hellip; <a class=\"more-link\" href=\"https:\/\/viewmyprojects.com\/winwirewp\/blog\/filters-in-power-bi\/\">Continue reading <span class=\"screen-reader-text\">How to Disable Values in Filter Pane for Filters in Power BI Report<\/span><\/a><\/p>\n","protected":false},"author":39,"featured_media":16352,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[59,60],"tags":[],"class_list":["post-11217","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogs","category-data-and-ai-blogs","entry"],"acf":[],"featured_image_src":"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI.webp","author_info":{"display_name":"Raghavender","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/raghavender\/"},"views":4894,"uagb_featured_image_src":{"full":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI.webp",800,440,false],"thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI-150x150.webp",150,150,true],"medium":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI-300x165.webp",300,165,true],"medium_large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI-768x422.webp",750,412,true],"large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI.webp",750,413,false],"1536x1536":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI.webp",800,440,false],"2048x2048":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI.webp",800,440,false],"post-thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/04\/Mar22_Blog_Power-BI.webp",800,440,false]},"uagb_author_info":{"display_name":"Raghavender","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/raghavender\/"},"uagb_comment_info":0,"uagb_excerpt":"Power BI provides offers rich visual that interacts well with the other visuals that are included on a Power BI report. However, one of the main complaints has been that the slices use up very precious screen real estate, especially when you are trying to add in data visuals onto a report. Filters were previously&hellip;&hellip;","_links":{"self":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/11217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/comments?post=11217"}],"version-history":[{"count":2,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/11217\/revisions"}],"predecessor-version":[{"id":17813,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/11217\/revisions\/17813"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media\/16352"}],"wp:attachment":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media?parent=11217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/categories?post=11217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/tags?post=11217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}