Search code examples
datepowerbitranslation

Power Bi dates not translating

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. enter image description here

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

enter image description here

  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!

Solution

  • 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