{"id":2049,"date":"2019-02-03T13:23:30","date_gmt":"2019-02-03T12:23:30","guid":{"rendered":"http:\/\/didier.terrien.free.fr\/powerbi\/?p=2049"},"modified":"2021-03-25T16:35:35","modified_gmt":"2021-03-25T15:35:35","slug":"3-display-filters-applied-to-data","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2019\/02\/03\/3-display-filters-applied-to-data\/","title":{"rendered":"3. Display filters applied to data"},"content":{"rendered":"\n<p>To understand properly our data, the very first thing we need to do is to perfectly know the filters applied to data. There are many ways to filter data (in the data source, in Power Query, in report\/page\/visual filters, slicers, &#8230;). So if you don&#8217;t understand your filters, you don&#8217;t understand your data. I will show you here how I display dynamically the filters applied to data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to display filters applied to data<\/h2>\n\n\n\n<ul><li>Create a measure in the table which is meant to be filtered<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Selected filters = \nVAR CR_LF = \"\n    \"   \/\/ This is a simple carriage return\nVAR Company = IF(ISFILTERED(Customers&#91;CompanyName]) ; \n                \"Company = \" &amp; CONCATENATEX(ALLSELECTED(Customers&#91;CompanyName]) ; Customers&#91;CompanyName] ; \" , \") &amp; CR_LF ; \"\")\nVAR Category = IF(ISFILTERED(Categories&#91;CategoryName]) ; \n                \"Category = \" &amp; CONCATENATEX(ALLSELECTED(Categories&#91;CategoryName]) ; Categories&#91;CategoryName] ; \" , \") &amp; CR_LF ; \"\")\nVAR Product = IF(ISFILTERED(Products&#91;ProductName]) ; \n                \"Product = \" &amp; CONCATENATEX(ALLSELECTED(Products&#91;ProductName]) ; Products&#91;ProductName] ; \" , \") &amp; CR_LF ; \"\")\n\nRETURN  Company &amp; Category &amp; Product <\/code><\/pre>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right\" style=\"grid-template-columns:auto 16%\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"178\" height=\"291\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Add-the-Selected-filters-measure-to-the-table.png\" alt=\"filters\" class=\"wp-image-2056 size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<ul><li>Add a table visual to your &#8216;Filters&#8217; page<\/li><li>Add the &#8216;Selected filters&#8217; measure to the table<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<p><strong>Don&#8217;t forget to update your &#8216;Selected filters&#8217; measure and your &#8216;Clear filters&#8217; bookmark when you add more slicers to the &#8216;Filters&#8217; page.<\/strong><\/p>\n\n\n\n<p>Select some filters and see how the &#8216;Selected filters&#8217; responds.<\/p>\n\n\n\n<p>Here is the pbix file of the demo :   <a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/didierterrien\/Power-BI-assistant\" target=\"_blank\">download demo &#8216;Report filters.pbix&#8217;<\/a> <\/p>\n\n\n\n<p>This post is a part of a series :   <a href=\"https:\/\/thebipower.fr\/index.php\/category\/power-bi-desktop\/report-filters\/\">see the series<\/a>   &#8211;   <a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/04\/4-add-a-tooltip-to-display-applied-filters\/\">see next post<\/a><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\t\t\t<div class=\"wp-block-uagb-post-carousel uagb-post-grid  uagb-post__image-position-top uagb-post__image-enabled uagb-block-8f36f7cf     uagb-post__arrow-outside uagb-slick-carousel uagb-post__items uagb-post__columns-3 is-carousel uagb-post__columns-tablet-2 uagb-post__columns-mobile-1\" data-total=\"1\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/05\/03\/5-add-your-filtered-date-range-in-the-tooltip\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"316\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/05\/Add-your-filtered-date-range-in-the-tooltip.png\" class=\"attachment-large size-large\" alt=\"Add your filtered date range in the tooltip\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/05\/Add-your-filtered-date-range-in-the-tooltip.png 566w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/05\/Add-your-filtered-date-range-in-the-tooltip-300x167.png 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/05\/03\/5-add-your-filtered-date-range-in-the-tooltip\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">5. Add your filtered date range in the tooltip<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Don&#8217;t forget to add your filtered date range in the tooltip. This is one of&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2019\/05\/03\/5-add-your-filtered-date-range-in-the-tooltip\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/04\/4-add-a-tooltip-to-display-applied-filters\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"290\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png\" class=\"attachment-large size-large\" alt=\"tooltip to display applied filters\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png 627w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip-300x139.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/04\/4-add-a-tooltip-to-display-applied-filters\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">4. Add a tooltip to display applied filters<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Once you know your report is filtered having a look at the green light, you&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/04\/4-add-a-tooltip-to-display-applied-filters\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/02\/2-display-a-light-when-data-is-filtered\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"572\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Light-is-green-1024x572.png\" class=\"attachment-large size-large\" alt=\"Display a light when data is filtered\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Light-is-green-1024x572.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Light-is-green-300x167.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Light-is-green-768x429.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Light-is-green.png 1089w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/02\/2-display-a-light-when-data-is-filtered\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">2. Display a light when data is filtered<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>When we use a report, it&#8217;s important to know if users applied filters. So, you&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/02\/2-display-a-light-when-data-is-filtered\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/01\/add-a-filter-page-to-your-report\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"455\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Filters-1-1-1024x455.png\" class=\"attachment-large size-large\" alt=\"Filters\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Filters-1-1-1024x455.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Filters-1-1-300x133.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Filters-1-1-768x342.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Filters-1-1.png 1059w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/01\/add-a-filter-page-to-your-report\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">1. Add a filter page to your report<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>There are different ways to filter data in Power BI reports. My favorite one is&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/01\/add-a-filter-page-to-your-report\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>To understand properly our data, the very first thing we need to do is to perfectly know the filters applied to data. There are many ways to filter data (in the data source, in Power Query, in report\/page\/visual filters, slicers, &#8230;). So if you don&#8217;t understand your filters, you don&#8217;t understand your data. I will&#8230;<\/p>\n","protected":false},"author":2,"featured_media":2603,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[4],"tags":[48,24,63],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png",456,294,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data-300x193.png",300,193,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png",456,294,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png",456,294,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png",456,294,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png",456,294,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png",456,294,false]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":0,"uagb_excerpt":"To understand properly our data, the very first thing we need to do is to perfectly know the filters applied to data. There are many ways to filter data (in the data source, in Power Query, in report\/page\/visual filters, slicers, &#8230;). So if you don&#8217;t understand your filters, you don&#8217;t understand your data. I will...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/2049"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2049"}],"version-history":[{"count":9,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/2049\/revisions"}],"predecessor-version":[{"id":3829,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/2049\/revisions\/3829"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/2603"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=2049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=2049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}