How To Create Multilingual Power BI Reports

[@lellasaikrishna8037]

Hi , Could you please post the dax expression used for the measure "Product", "Status", "Province", "Country", "Continent".

[@tengnbiiga]

Excellent explanation! Is there a way to translate data labels on charts, ie on a pie chart? There is no fx field like for the Title, and I can't find a solution that doesn't involve an external tool like Translations Builder, which my employer does not allow.

[@EnterpriseDNA]

Hello Samuel, No, currently there's no way to simply translate the data labels since there's no option of fx available under that section of the pie chart but you can change the titles and sub-titles with the option of fx provided by Power BI. And since external tools are not an option in your scenario, there's no way out here unless Power BI adds those options inside the visualizations. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on Power BI, Power Platform, and the Microsoft stack updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@mariya7048]

Can u provide atleat one dax for that columns eg:country

[@radhakrishnag9673]

Hi There, Where are we linking (04:23) Single select slicer and (04:40) Navigation buttons , these 2 components in the report functionality?

[@EnterpriseDNA]

Hello Radhakrishna G, Thank You for posting your query onto our channel. Well your question is not clear to us here and we insist you to please write back to us by elaborating your query further about what actually you're trying to highlight here. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Also make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@brianjulius6401]

Excellent. I always really appreciate the level of detail and precise explanations in your videos.

[@FethiELHADJALI]

Good morning, I am interested in your "multilingual" presentation. Could you please send me the PBIX report (How To Create Multi-Lingual")

[@EnterpriseDNA]

Hi Fethi, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers! Sign up here: app.enterprisedna.co/sign-up

[@FethiELHADJALI]

@@EnterpriseDNA Thank you, unfortunately I can't find the report, apparently there is a permission problem

[@victoranton6744]

Thank you for your video, please could you explain how to create dependencies between buttons and sliders ( I mean when you navigate to the FR screen with the button French, and the slider selected language changes automatically to FR)?? 🙏🙏

[@avelinomcneto]

Hi, thank you for the video. I accessed the portal and it was remodeled and even though it became a membership I was unable to access it. Could you tell us what the name of the course is on the new platform?

[@suniltak5707]

Hi, thanks for the video! Great approach for multilingual reports. Can we change the report name as well in selected language? Let's say i have a report and I want to show report name "Report 1" for English language and "Report 1 French" for French language. Is this possible ? Thanks in advance.

[@EnterpriseDNA]

Hey Sunil, Unfortunately, Power BI doesn't have the option to showcase a report name with multiple languages currently. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@divyadivya3486]

Hi , Could you please post the dax expression used for the measure Selected Language Code

[@EnterpriseDNA]

Hello divya divya, thank you for posting your query onto our channel. Below is the measure for "Selected Language Code" provided for the reference - Selected Language Code = SWITCH( TRUE() , SELECTEDVALUE( Languages'[Language EN] ) = "English" , "EN" , SELECTEDVALUE( Languages'[Language EN] ) = "French" , "FR" , SELECTEDVALUE( Languages'[Language EN] ) = "Spanish" , "ES" , "EN" ) For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Also make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@divyadivya3486]

@@EnterpriseDNA Thank you so much for posting the reply.

[@andrealvarez231]

@@EnterpriseDNA Hi, thanks for the video!! Great approach for multilingual reports. Could you please post the dax expression used for the measures in Columns folder (Continent, Country, Product, etc)?

[@andrealvarez231]

Hi, thanks for the video! Great approach for multilingual reports. Could you please post the dax expression used for the measures in Columns folder (Continent, Country, Product, etc)?

[@EnterpriseDNA]

Hi Andre, thanks for posting your comment in the video. All pbix file/datasets/measures are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Thanks! portal.enterprisedna.co/

[@mariya7048]

Did u downloaded 🤔

[@ductienk40tm]

could you help with codes for measure on transactions on the transactions reports?: continent, country, product, statsus...i dont know how to make the transactions reports switching between languages, you did not show how to make the report connecting with language filter, its hard to follow the steps. thanks and where did you apply report_title measure to? u show the code but we dont know where u use it? quite confusing to follow.

[@EnterpriseDNA]

Hi Tien, all pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via a Subscription. Check out the link below. Cheers! portal.enterprisedna.co/

[@mariya7048]

Did u downloaded

[@diegomelon8400]

Thank you Greg! Could you upload the pbix, please? Thank you in advanced,

[@gregphilpsful]

Hi Diego ... the PBIX is available to Enterprise DNA members and is in the same-named item within the "Best Practices & Features Review" module.

[@adeyeyetemitayo7383]

@@gregphilpsful . Thanks for the explanation. I have checked the said module but didn't see the pbix.

[@pradeepkumarreddy5481]

@@gregphilpsful No PBIX file, I have subscribed to enterprisedna for this PBIX file. Please help me out

[@manuelasierra4279]

​@@pradeepkumarreddy5481 hello, did you manage to get the PBIX file? or DAX functions used in column measures?

[@manuelasierra4279]

hello, did you manage to get the PBIX file? or DAX functions used in column measures?

[@manuelasierra4279]

Hola, me puedes compartir el ejercicio para analizarlo con detenimiento?

[@EnterpriseDNA]

Hi Manuela, all pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Cheers! portal.enterprisedna.co/

[@didierterrien6933]

Thank you for the video ! Great explanations Why don't you use translations using Tabular Editor or Metadata translations external tools ? With this technique, you will have only one page.

[@gregphilpsful]

Government clients (in my experience, at least) often have very specific translation requirements, and external tools are rarely available/permitted; hence the workaround

[@darrylmorgan]

Really Intresting Technique...Thank You Greg

[@EnterpriseDNA]

Hi darryl morgan, thank you for always supporting our videos.

[@jameswindrem135]

Wondering if the dax expression used to create the measures for the column data is the same as the one used for the report labels? Translating the labels is simple enough from your video but translating the column data has me stumped

[@EnterpriseDNA]

Hello James, Thank you for posting your query onto our channel. Well, your question is not clear to us here. Could you please write back to us again onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@memorizeitall]

I will have a detailed look at your solution. I am creating international trade statistics with 13 different languages :-) Have some real difficulties in setting things up... It was not easy but possible to do this in Excel... But want to move to Power BI, due to less limitations and more options etc.

[@AndrewMcDonald123]

I assume this can this be embedded as well?

[@EnterpriseDNA]

Hello Andrew McDonald, thank you for posting your query onto our channel. Yes, definitely this thing can be embedded as well. The main motive of this content was to showcase that basically "How To Create Multi-Lingual" reports in Power BI. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Also make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/

[@scottstanek3077]

What about this option: Original table is in original language in Excel say Tbl1. Copy the header column into a new spreadsheet and use Goodle translate doc on it. Copy the result back ina new sheet Tbl1_SP, repeating steps with French for Tbl1_FR (both with no rows). Import all three versions into your PBX. Then make DAX versions that are Tbl1_d_FR = UNION(Tbl1_FR, Tbl1) and Tbl1_d_EN = UNION(Tbl1_EN, Tbl1) (in this example the first table is in Spanish).The only sore spot is by testing this I found I need to put in 1 row of empty values formatted as the 0.0 numeric and then transform, remove 1 row so they would be in the right data type in the UNION. (Not have to pick SUM of manually). I don't see an easy way change the DAX to an IF statement about which things to UNION based on a slicer. If the tables change (such as bad translations) just delethe imported header table and reimport it wih the correction. PROS: One set of data per table. Column names follow the data. CONS: You do have to know what they are to pick them. YMMV

[@martiruda]

I built a language database that takes another approach but it's awesome how flexible power BI can be

[@EnterpriseDNA]

Hi Marcelo Silva, glad you appreciated the video. We are so grateful to have had such positive feedback.

[@martiruda]

@@EnterpriseDNA you have amazing content !!

[@David-op8go]

Instead of creating multiple columns for your data and then measures.. just create one more column with a language short. Create a language table and connect the language short with the language table to filter. And then „copy paste“ your data three times underneath, each copy in a another language and its much cleaner

[@gregphilpsful]

Thanks David. My solution reflects the way many of my government clients currently store their data. I'd be interested to see your approach ... if possible, could you post a sample PBIX on the Enterprise DNA support forum?

[@zm2813]

David, good suggestion. I personally think your scenario works best for smaller tables or if the data is small. If you have 3 source tables, then you'd need to deal with them separately or alternatively you can merge them by creating the index column as you suggested.