Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jguerrero
Helper II
Helper II

Multiligual Dynamic Labels Not Working

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.

 

 

jguerrero_1-1672719173496.png

 

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:

jguerrero_0-1672719063800.png

 

What am I doing wrong?

 

Thanks in advance.

3 REPLIES 3
jguerrero
Helper II
Helper II

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. 

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

 

 

 

 

 

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Idrissshatila
Super User
Super User

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.