cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mizaskun
Helper II
Helper II

Multilingual report maintain filter values translated

Is there any way I can build a multiligual report so that when I filter it by e.g. France country out of France, UK and China, if I change the report language to spanish it maintains the France filter translated to Francia? It should change to Francia out of Francia, UK and China. 

 

I reviewd many different ways to build a multilingual report but could not come up with the way to solve this issue.

 

Any suggestion? 

 

Let's say we have the following fact table:

ID - Country - Product - Amount

1 - FR - 1- 7

2 - FR - 1 - 13

3 - SP - 2 -19

 

The following Country master:

CODE - Langu - Name

FR - S - Francia

SP - S - España

CN - S - China

FR - E - France

SP - E - Spain

CN - E - China

 

And the following Product master

ID - Langu - Name

1 - S - Leche

2 - S - Agua

1 - E - Milk

2 - E - Water

 

Thank you so much in advance!!! 

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @mizaskun ,

For multiple language report, I suggest you refer this community blog which introduces it in details:

Transform ‘report language’ based on buttons  

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yingjl
Community Support
Community Support

Hi @mizaskun ,

For multiple language report, I suggest you refer this community blog which introduces it in details:

Transform ‘report language’ based on buttons  

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.