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
dgonda
Helper I
Helper I

Can you translate reports based on tags?

Hi,

Title says it all, can you translate reports with tags? I have a tag table with tags for every header, title, axis, etc, I'd like to use them to create a multilingual report where these tags get switched out based on the selected language. An example tag:

dgonda_0-1626186331206.png

 

3 REPLIES 3
Greg_Deckler
Super User
Super User

@dgonda Well, let's say you have a Card visualization. You could create a measure that selected the right row/column using what I am assuming is the TagId and LanguageId like:

 

Measure = 
  VAR __TagId = 1
  VAR __LanguageId = MAX('Language'[LanguageId])
RETURN
  MAXX(FILTER('Tags',[TagId] = __TagId && [LanguageId] = __LanguageId),[TagText])

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

@dgonda In theory yes, but not entirely certain there is enough information to go on to be specific around how. It is going to vary based upon use case.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler Could you tell me an example? Or what other information should I provide? Because I'm pretty stuck with this.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.