{"id":3714,"date":"2021-11-04T10:57:55","date_gmt":"2021-11-04T17:57:55","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3714"},"modified":"2021-11-04T10:57:56","modified_gmt":"2021-11-04T17:57:56","slug":"dynamically-changing-title-names-in-power-bi","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3714","title":{"rendered":"Dynamically Changing Title Names in Power BI"},"content":{"rendered":"\n<p>By: &nbsp;MITCHELL PEARSON<\/p>\n\n\n\n<p>Hey Everyone! I\u2019m excited that I\u2019m finally getting this blog done! Also, I\u2019ve embedded the YouTube video below&nbsp;<img decoding=\"async\" alt=\"Smile\" src=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/wlemoticon-smile-1.png?w=676\"><\/p>\n\n\n\n<p>Also, in other news, after 8 years of blogging I finally decided to make some kind of logo, it\u2019s a little unique but I like it! Especially how I was able to sneak the board game in there because I love board games!<\/p>\n\n\n\n<p>Here is the video posted on YouTube if you want to watch the steps in action.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Dynamic Title Names in Power BI using SelectedValue and Conditional Formatting\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/ZBDKIV-Lyz4?start=16&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">What is a Dynamic Title in Power BI?<\/h2>\n\n\n\n<p>The idea around a dynamic title is that the name of the title changes automatically to reflect any filters that may be applied. In the automated gif below, watch how the title name changes as I drill down into the chart visual.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/dynamictitles.gif\"><img decoding=\"async\" src=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/dynamictitles_thumb.gif?w=539&amp;h=391\" alt=\"DynamicTitles\" title=\"DynamicTitles\"\/><\/a><\/figure>\n\n\n\n<p><em>Figure 2 \u2013 Dynamic title, animated gif<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating Dynamic Titles in Power BI with SELECTEDVALUE() Function<\/h2>\n\n\n\n<p>Creating the dynamic title you saw in Figure 2 above requires a little DAX, not much. First, create a new calculated measure and give it a name, in the YouTube video I called this measure Dynamic Title. Then I used the following expression:<\/p>\n\n\n\n<p id=\"inline-ad-1\">Advertisementshttps:\/\/c0.pubmine.com\/sf\/0.0.3\/html\/safeframe.htmlREPORT THIS AD<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/image-2.png\"><img decoding=\"async\" src=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/image_thumb-2.png?w=668&amp;h=76\" alt=\"image\" title=\"image\"\/><\/a><\/figure>\n\n\n\n<p>This is a simple expression which will return the name of the country if only one country exist in the filter context, if not, it will return the text \u201cAll Countries\u201d. In this example I am navigating a hierarchy, therefore, I want the title name to change for each level of the hierarchy as new filters are being applied. The following screenshot is the completed code from the video:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/image-3.png\"><img decoding=\"async\" src=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/image_thumb-3.png?w=662&amp;h=122\" alt=\"image\" title=\"image\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conditional Formatting in Power BI on the Title of a visual<\/h2>\n\n\n\n<p>The final step is to use the calculated measure on the visualization with the following steps, see animated gif for reference:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Select visual and navigate to the formatting pane<\/li><li>Find the title category and expand it.<\/li><li>Click on the&nbsp;<em>fx&nbsp;<\/em>icon next to title<\/li><li>Select field value for Format By<\/li><li>Select your measure from the drop down list for Based on Field.<\/li><li>That\u2019s it!<\/li><\/ol>\n\n\n\n<p>As always, hope this post helped!<\/p>\n\n\n\n<p id=\"inline-ad-2\">Advertisementshttps:\/\/c0.pubmine.com\/sf\/0.0.3\/html\/safeframe.htmlREPORT THIS AD<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/2_conditional-formatting.gif\"><img decoding=\"async\" src=\"https:\/\/mitchellsql.files.wordpress.com\/2020\/12\/2_conditional-formatting_thumb.gif?w=1040&amp;h=471\" alt=\"2_Conditional Formatting\" title=\"2_Conditional Formatting\"\/><\/a><figcaption>Ref: https:\/\/mitchellpearson.com\/2020\/12\/29\/dynamically-changing-title-names-in-power-bi\/<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>By: &nbsp;MITCHELL PEARSON Hey Everyone! I\u2019m excited that I\u2019m finally getting this blog done! Also, I\u2019ve embedded the YouTube video below&nbsp; Also, in other news, after 8 years of blogging I finally decided to make some kind of logo, it\u2019s a little unique but I like it! Especially how I was able to sneak the <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3714\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[922],"class_list":["post-3714","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-dynamically-changing-title-names-in-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3714"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3714\/revisions"}],"predecessor-version":[{"id":3737,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3714\/revisions\/3737"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}