https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2166604#M50229 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="335913" data-lia-user-login="matalb" class="lia-mention lia-mention-user">matalb</a>,</P> <P>You can create a Calculated Column using the SWITCH function:</P> <LI-CODE lang="markup">Dynamic Title = SWITCH ( 'Graphics Table'[variable], "1st graph title", 'Graphics Table'[text] )</LI-CODE> <P>Then click on your visual, go to Title text, and click the function key.</P> <P><img /></P> <P>Find the new calculated column and click it.&nbsp;</P> <P><img /></P> <P><img /></P> <P><img /></P> <P>Hope this helps.</P> Mon, 01 Nov 2021 16:02:01 GMT Watsky 2021-11-01T16:02:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2163766#M50058 <P>I have this table with graphics titles, cards and filters for each language (Spanish and Portuguese).</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>I'm new to DAX how can I create a measure that dynamically changes the title of this chart as I filter the page by "ES" or "PT" (Spanish or Portuguese, respectively?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 29 Oct 2021 19:51:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2163766#M50058 matalb 2021-10-29T19:51:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2166445#M50212 <P>any idea? help!</P> Mon, 01 Nov 2021 14:19:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2166445#M50212 matalb 2021-11-01T14:19:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2166604#M50229 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="335913" data-lia-user-login="matalb" class="lia-mention lia-mention-user">matalb</a>,</P> <P>You can create a Calculated Column using the SWITCH function:</P> <LI-CODE lang="markup">Dynamic Title = SWITCH ( 'Graphics Table'[variable], "1st graph title", 'Graphics Table'[text] )</LI-CODE> <P>Then click on your visual, go to Title text, and click the function key.</P> <P><img /></P> <P>Find the new calculated column and click it.&nbsp;</P> <P><img /></P> <P><img /></P> <P><img /></P> <P>Hope this helps.</P> Mon, 01 Nov 2021 16:02:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-dynamic-label-using-a-language-filter/m-p/2166604#M50229 Watsky 2021-11-01T16:02:01Z