Multilingual report maintain filter values translated

[mizaskun]

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!!! 

[v-yingjl · Accepted solution]

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.