The selection of the selected bookmark is done via the user interface. Unfortunately at the moment bookmarks cannot be selected depending on values. Settings Bookmark englishДЄnd hereвЂ™s the same for the German bookmark: Settings Bookmark deutsch Control bookmarks via the GUI The red mark shows the hidden status of the German visual. Here are the settings for the English bookmark. The first bookmark вЂњbm_englishвЂќ hides the German visual, the bookmark вЂњbm_deutschвЂќ shows only the German visual and hides the English visual. English DiagrammДЄt the moment the report looks like this: Diagramms in English and German Create bookmarks We can ignore the message and create a new bar chart on the left, this time with the English terms. Now we immediately receive an error message in the visual. Power BI tells us that we still have to activate the change. Parameterwert Г¤ndernД®nglishвЂќ is selected as the new language. All we have to do is change the value of the parameter in the user interface. The report user should be able to change the language as easily as possible.

Diagramm with name und measure in German Changing the parameter Next, at the center of the report layout, we create a normal bar graph consisting of the Name column and the вЂњUmsatzвЂќ measure. Since the language is set to вЂњDeutschвЂќ, DAX does not find the column Sales. When writing the вЂњRevenueвЂќ measure, Power BI immediately responds with an error message. The sales measure should also change the name depending on the language. For Sales it looks like this: Language = if pmt_Language = 'english' then #'Changed Type' else If Deutsch is selected, the column names must be adapted. In the case of English, the table remains unchanged, since the source language of the table is English. This condition checks which language was selected in the parameter. To do this, we enter an if-then condition in the Advanced Editor. With the created parameter we can now also easily adjust the column headings.

Parameter вЂњpmt_LanguageвЂќ Adjust column headersДЇor this example I have created a data set consisting of two tables вЂњSalesвЂќ and вЂњCustomersвЂќ. In this case this will be a list which is defined below (3) with вЂњDeutschвЂќ and вЂњEnglishвЂќ.ДЄs default value (4) I have defined вЂњDeutschвЂќ, which also corresponds to the current value (5). The parameter needs a name (1) as well as a selection option (2). Parameters can be easily created in Power Query: Create new parameter I named the parameter pmt_Language and have two choices: вЂњGermanвЂќ and вЂњEnglishвЂќ. What we need is a parameter in Power Query. The report recipient should be able to change the language with as little effort as possible.The visuals should be displayed depending on the selected language.Furthermore, the measures must be translated (for example, вЂњrevenueвЂќ must become вЂњUmsatzвЂќ).Depending on the selected language, the column headings have to be adjusted.In order to meet the above-mentioned customer needs, the following challenges must be mastered: If you are looking for a solution for changing the values in a column, I can recommend you the YoutubeВ video by Ruth Pozuelo ( ) and the one by Adatis. This means that the product name вЂњRoadBikeвЂќ can remain unchanged. However, the contents of the individual fields do not have to be changed. Both the column headings in the tables and the measures should be displayed in the required language.

It may be a customer request that the reports have to be displayed in either English or German.

Umsatz diagramm