Multiligual Dynamic Labels Not Working

[jguerrero]

First of all, happy new year to everyone.

I have a dashboard that I need it to be in Spanish and English, but some aspects are not qirking. 

As a little bit f background, access to the dashboard is controlled by a table called ACCESS that has RLS using the field EMAIL and the USERPRINCIPALNAME() function. This is working OK.

I tried to create some dynamic titles based on the above LANGUAGE field. The values used are “EN” for English and “ES” for Spanish. Every time a user is connected, RLS filters the ACCESS table based on the EMAIL and the LANGUAGE field is also filtered.

To get a dynamic label, I use the MIN(ACCESS[LANGUAGE]) to get the filtered unique value of the LANGUAGE field in the formulas as follows:

Tons =

VAR _CurrentValue = "English Default"

VAR _ValueEN = LOOKUPVALUE(Translations[DESCRIPTION],Translations[NAME],"LandingTon",Translations[LANGUAGE],"EN")

VAR _ValueES = LOOKUPVALUE(Translations[DESCRIPTION],Translations[NAME],"LandingTon",Translations[LANGUAGE],"ES")

VAR _Result =

    SWITCH(TRUE(),

        MIN(Access[LanguageCd]) = "ES",_ValueES,

        _ValueEN

    )

RETURN _Result

The avobe measure goes t the TRANSLATIONS table and brings the VOLUME IN TONS titlein English or Spanish.

This is also working OK.

HERE IS MY PROBLEM…

I need to change the name of the values inside the visuals. Let’s say the name of the month from the CALENDAR table. For this, I created the COLUMNS:

Year Month English =

SWITCH (

    'Calendar'[Month Number],

    1, 'Calendar'[Year]& "-" & "Jan",

    2, 'Calendar'[Year]& "-" & "Feb",

    3, 'Calendar'[Year]& "-" & "Mar",

    4, 'Calendar'[Year]& "-" & "Apr",

    5, 'Calendar'[Year]& "-" & "May",

    6, 'Calendar'[Year]& "-" & "Jun",

    7, 'Calendar'[Year]& "-" & "Jul",

    8, 'Calendar'[Year]& "-" & "Aug",

    9, 'Calendar'[Year]& "-" & "Sep",

    10, 'Calendar'[Year]& "-" & "Oct",

    11, 'Calendar'[Year]& "-" & "Nov",

    12, 'Calendar'[Year]& "-" & "Dec",

    "Other Month"

)

And

Year Month Spanish =

SWITCH (

    'Calendar'[Month Number],

    1, 'Calendar'[Year]& "-" & "Ene",

    2, 'Calendar'[Year]& "-" & "Feb",

    3, 'Calendar'[Year]& "-" & "Mar",

    4, 'Calendar'[Year]& "-" & "Abr",

    5, 'Calendar'[Year]& "-" & "May",

    6, 'Calendar'[Year]& "-" & "Jun",

    7, 'Calendar'[Year]& "-" & "Jul",

    8, 'Calendar'[Year]& "-" & "Ago",

    9, 'Calendar'[Year]& "-" & "Sep",

    10, 'Calendar'[Year]& "-" & "Oct",

    11, 'Calendar'[Year]& "-" & "Nov",

    12, 'Calendar'[Year]& "-" & "Dic",

    "Otro Mes"

)

And I use the next formula (column) to change the month titles:

Language Year Month =

SWITCH(TRUE(),

    Access[MinLanguage] = "ES",

    'Calendar'[Year Month Spanish],

    'Calendar'[Year Month English]

 )

But the above formula always returns ENGLISH regardless of the ACESS[MinLanguage] value:

What am I doing wrong?

Thanks in advance.

[jguerrero]

Thank you for the qucik response, Idrissshatila.

It is pretty much the same I have done and it is still not working. 

It helped me to change the COLUMNS and MEASURES to be part of the calendar table using the CULTURE argument in the table, but still, the LANGUAGE is not changing.

Thank you very much for the assitance. 

[Idrissshatila]

I wish I could help you to solve it as you want. 

If I answered your question, please mark my post as solution so it would appear to others, Appreciate your Kudos👍

Follow me on Linkedin

[Idrissshatila]

Hello,

This video would help you in your request
https://www.youtube.com/watch?v=sCVQUXS8WwY&t=869s

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin