Dynamic legends based on user

[Anonymous]

My data looks like this. I have a table and want to filter it on English or France, based on the current user.

Table data

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, column of Status is entered as the measure on the Y-axis..

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.

Best, Erik

[Greg_Deckler]

@Anonymous 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. (1) Localizing the Data Model - Part 3 - Microsoft Power BI Community