https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-legends-based-on-user/m-p/2780660#M5225 <P>My data looks like this. I have a table and want to filter it on English or France, based on the current user.</P><P><A href="https://i.stack.imgur.com/isJMN.png" rel="nofollow noreferrer" target="_blank">Table data</A></P><P>If I choose company E, I only want to show the three labels "started", "not started" and "finished". If I choose company F, I only want to show the three analogous labels in French. Right now, all six labels of Status show up when using the column as value, <SPAN>column of Status is entered as the measure on the Y-axis.</SPAN>.</P><P>Is there any way this is doable? I'd prefer not to split up my data into to different tables, since new data keeps coming into my database.</P><P>Best, Erik</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 20 Sep 2022 12:27:12 GMT Anonymous 2022-09-20T12:27:12Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-legends-based-on-user/m-p/2780660#M5225 <P>My data looks like this. I have a table and want to filter it on English or France, based on the current user.</P><P><A href="https://i.stack.imgur.com/isJMN.png" rel="nofollow noreferrer" target="_blank">Table data</A></P><P>If I choose company E, I only want to show the three labels "started", "not started" and "finished". If I choose company F, I only want to show the three analogous labels in French. Right now, all six labels of Status show up when using the column as value, <SPAN>column of Status is entered as the measure on the Y-axis.</SPAN>.</P><P>Is there any way this is doable? I'd prefer not to split up my data into to different tables, since new data keeps coming into my database.</P><P>Best, Erik</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 20 Sep 2022 12:27:12 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-legends-based-on-user/m-p/2780660#M5225 Anonymous 2022-09-20T12:27:12Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-legends-based-on-user/m-p/2780699#M5226 <P>@Anonymous&nbsp;I wrote a whole blog series about stuff like this. The short answer is to just use English or French and do the translation in the browser.&nbsp;<A href="https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-3/ba-p/2071522" target="_blank" rel="noopener">(1) Localizing the Data Model - Part 3 - Microsoft Power BI Community</A></P> Tue, 20 Sep 2022 12:41:09 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-legends-based-on-user/m-p/2780699#M5226 Greg_Deckler 2022-09-20T12:41:09Z