Power Bi dates not translating

Question

I am translating a Power Bi report to Russian and the dates are persistently showing in English.

I have set the report locale to Russian and changed the Date column type to Russian.

I have created a new column to sort data by month, but the months still show in English.

  Could someone please explain my error? As we want to translate to more languages I do not want to have to rebuild the entire project each time!

Many thanks for advice on this!

Answer 1

You could use the location identifier in the month column using the FORMAT statement:

MonthYear = FORMAT([Date], "mmm yyyy", "ru-RU")

Details of the optional argument that specifies the locale identifier for the FORMAT statement taken from here: https://dax.guide/format/

Answer 2

A new column is needed in this situation, because the MonthYear column is a text column.

1. Create a new month column - example below.
2. Create a Year column from the date column in your dataset (Year = FORMAT([Date], "yyyy"))
3. Merge the new month column and the Year column (RUS_Month_Year = COMBINEVALUES(" ", [RussianMonth], [Year])

Example of new month column (Russian):

RussianMonth = SWITCH(MONTH([Date]),1, "Янв", 2, "Фев", 3, "Мар", 4, "Апр", 5, "Май", 6, "Июн", 7, "Июл",  8, "Авг", 9, "Сен", 10, "Окт", 11, "Ноя", 12, "Дек", "Unknown month number" )

With thanks to discussion in Change month name language

Answer 3

You need to change the default language in your Windows settings. The same applies to Power BI Service.

Locale is just to import the data in the correct format.

If I set my default language to Spanish

And if I go back to English

You need to reopen the Power BI workbook to see the changes.