{"id":2060,"date":"2019-02-04T13:03:05","date_gmt":"2019-02-04T12:03:05","guid":{"rendered":"http:\/\/didier.terrien.free.fr\/powerbi\/?p=2060"},"modified":"2020-12-16T13:51:10","modified_gmt":"2020-12-16T12:51:10","slug":"4-add-a-tooltip-to-display-applied-filters","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2019\/02\/04\/4-add-a-tooltip-to-display-applied-filters\/","title":{"rendered":"4. Add a tooltip to display applied filters"},"content":{"rendered":"\n<p>Once you know your report is filtered having a look at the green light, you expect to get more details. So add a tooltip to display applied filters.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to add a tooltip to display applied filters<\/h2>\n\n\n\n<ul><li>Create a tooltip page, name it &#8216;TT filters&#8217; and hide this page. See this blog post if you don&#8217;t know how :  <a rel=\"noreferrer noopener\" label=\" (opens in a new tab)\" href=\"https:\/\/thebipower.fr\/index.php\/category\/power-bi-desktop\/tooltips\/\" target=\"_blank\">create a tooltip page<\/a><\/li><li>Add a table visual to your &#8216;TT filters&#8217; page  and maximize it to the tooltip size<\/li><li>Add the &#8216;Selected filters&#8217; measure to the table <\/li><li>Set the header width of the table to be not automatic and adjust the width manually <\/li><\/ul>\n\n\n\n<p>From now on, when your mouse hovers the green light, the &#8216;TT filters&#8217; tooltip will appear showing the applied filters. It will work with any filter. Cross highlighting or cross filtering, slicers, page &amp; report filters in the visualization pane or in the filter pane will work.<\/p>\n\n\n\n<p>Your users will not ask you anymore how the report is filtered. They will simply open the tooltip to display applied filters. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Tips<\/h3>\n\n\n\n<p>A good practice is to display at least the green light near your KPIs to alert managers on the filtered context. Otherwise, you may display the whole applied filters like we did in the &#8216;Filters&#8217; tab.<\/p>\n\n\n\n<p>If you export your report to PDF, an other good practice is to show your applied filters in one of the first pages then your report will be auto documented. <\/p>\n\n\n\n<p>Here is the pbix file of the demo :   <a href=\"https:\/\/github.com\/didierterrien\/Power-BI-assistant\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"download demo 'Report filters.pbix' (opens in a new tab)\">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\/05\/03\/5-add-your-filtered-date-range-in-the-tooltip\/\">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\/03\/3-display-filters-applied-to-data\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"456\" height=\"294\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png\" class=\"attachment-large size-large\" alt=\"Display filters applied to data\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data.png 456w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-applied-to-data-300x193.png 300w\" sizes=\"(max-width: 456px) 100vw, 456px\" \/>\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\/03\/3-display-filters-applied-to-data\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">3. Display filters applied to data<\/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>To understand properly our data, the very first thing we need to do is to&#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\/03\/3-display-filters-applied-to-data\/\" 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>Once you know your report is filtered having a look at the green light, you expect to get more details. So add a tooltip to display applied filters. How to add a tooltip to display applied filters Create a tooltip page, name it &#8216;TT filters&#8217; and hide this page. See this blog post if you&#8230;<\/p>\n","protected":false},"author":2,"featured_media":2602,"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,31,63],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png",627,290,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip-300x139.png",300,139,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png",627,290,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png",627,290,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png",627,290,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png",627,290,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/02\/Display-filters-in-tooltip.png",627,290,false]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":0,"uagb_excerpt":"Once you know your report is filtered having a look at the green light, you expect to get more details. So add a tooltip to display applied filters. How to add a tooltip to display applied filters Create a tooltip page, name it &#8216;TT filters&#8217; and hide this page. See this blog post if you...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/2060"}],"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=2060"}],"version-history":[{"count":13,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/2060\/revisions"}],"predecessor-version":[{"id":3678,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/2060\/revisions\/3678"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/2602"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=2060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=2060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}