Creating A Single-Select Slicer For The Language Codes It looks up all three values for the label, and then it uses a simple SWITCH TRUE logic to return the appropriate label volume. First, it sets the name of the label that we’re going to be calculating. This is by no means an optimized DAX but rather, a measure written for clarity. These measures will take into account the language selected in our language slicer and then return the appropriate value for the selected language. Then we’ll need a set of translation measures, one for each label we’re going to display in our report. In here, we see a standard waterfall layout with dimensions on top, fact table in the middle, measure tables on the right,and supporting tables on the lower part. Let’s go to the modeling view and look at the simple data model we have. I’ve also loaded the extended date table from the Enterprise DNA forum. We’ll open the power query, and we can see that we have a table for each of the tabs that were in the Excel spreadsheet from earlier. Let’s now load and model our data in Power BI.
We’ll have a repository of the data and translations to present, and an Excel workbook with a tab for each data type.įirst, we need a table for the languages we’re going to support…Īnd then we need a set of dimensions with translations for all of the string values in each of the languages we’re going to support. The translations here are meant only to help illustrate the technique and are presented for purely educational purposes.ĭata Requirements Of A Multilingual Power BI Report I’m not saying that any of these are the appropriate translations, but rather they are the result of basic online translation tools. I’ve created a small sample data set, but please take all translations with a grain of salt.
The example I’ll be showcasing today uses a multilingual approach with solutions for presenting reports in English, French, or Spanish. As for the labels, a separate translation effort is often needed. With any multilingual report development effort, there are two main areas that require translated values: the report data and the report labels.įor the data, if one is charged with producing multilingual reports, one can hopefully access a data source that already contains the translations of data text values.
#Power bi report builder tutorial download#
Download Free Resources Here The Two Areas Of A Multilingual Power BI Report
0 kommentar(er)
