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

Bilingual dashboards, what's the best way for customers to switch languages on a report?

Hi all #PowerBIExperts,

I have to make all of my reports bilingually, I am able to do a lot by creating lookups.......overall this works mostly... but I have many limitations and somethings don’t work at all. Its very time consuming and I think there must be an easier way of doing this! I just don’t know it yet…..

So my question is can I switch columns or a table based on a selected value?

eg is there a way I can say if “English” is selected the use columns A, C, E, G
Or if “Welsh” is selected use columns B, D, F, H

Or if I can put all the Welsh in one table…..and English in another how can I switch when a language is selected?

None of the data is changing, only the text fields, in my example below, I have text fields like school name, catchment area, school type etc that would need to change.

These reports will be published to web so need to be controlled on the report page by the customer. Either by a slicer or a selection of some sort. 
Eng.PNGWelsh.PNG

2 REPLIES 2
Super User II
Super User II

Hi @Cbutler 

 

I found an interesting video may help you Multilanguage Multilingual reports in Power BI.

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Hi @Cbutler 

 

did you solve your problem?

 

If I answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors