Columns names translation

[baselamro]

Hello,

I have a PBI report in Dutch that I need to offer to my new audience (French speaking in my case). After a couple of attempts, I succeeded to get the titles and the names of the measures to appear in French based on the user's regional language settings using:

userculture()

My issue now is how to get the names of the fields/columns in French so that a colleague with a French regional language setting can see the names of the columns in French too.

According to some articles online, adding translation in Tabular would solve the issue, but for some reason, nothing happened at all after I added the translation. 

I would ideally, though, like to grab the translation from an Excel sheet so I don't need to add the translation to the fields one by one.

Any tips would be helpful 🙂

a sample of what I have done can be found here:

https://we.tl/t-XD9YcnfYTN

[baselamro]

Hello Idriss,

That's very helpful indeed!! Makes me think of how powerful M language can be! Thanks a lot!

[Idrissshatila · Accepted solution]

Hello @baselamro ,

Check if this video is helpful for your case https://www.youtube.com/watch?v=sCVQUXS8WwY&t=873s

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

Follow me on Linkedin

[Idrissshatila]

Hello @baselamro ,

Check if this video is helpful for your case https://www.youtube.com/watch?v=sCVQUXS8WwY&t=873s

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

Follow me on Linkedin