Forum Discussion
How to get multi language support for data by slicer (multiple cols per row should get one col)
It sounds simple, but I can not find a good solution.
I have a dimension table (product) with two column of the name, one in English, the other in German.
My table visual should show just one column "product name" with the content of the choosen language.
A single select slicer choose the language.
So the DAX somehow can do it, but it shows all possible row combinations, so I filtered down just if measure value exists.
But that is not a good solution as I have 50 measure which could be used in a table visual.
A calculated column also does not seem to work.
As this is a very common problem, I hope there is someone out with a solution... 🙂
Thx
Oliver
2 Replies
Anonymous
Check this blog, I guess this is what you are looking for.
Transform ‘report language’ based on buttons
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.Hi!
That is not feasable, similar to have several reports with the same content, but different text columns.
So all layout and visuals have to be designed and developed in future 3 times for each report.
If a report has 10 pages you have then 30 pages which look the same but still have to be managed seperatly...!
And this then for 20 reports!
In a real world project this is not a solution...
It is somehow needed to replace a colum with another and use it in a matrix and also on filter.
BR
Oliver