Forum Discussion

CJDK's avatar
CJDK
Helper II
5 years ago
Solved

Dates not translating

I am translating a 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!

 

 

 

 

Need Help
  • CJDK's avatar
    CJDK
    5 years ago

    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.
    3. Merge the new month column and the Year column.

    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.

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, CJDK 

    I think it has something to do with your computer setting, not power bi setting.

    please try to check the setting.

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    • CJDK's avatar
      CJDK
      Helper II
      5 years ago

      Thanks Jihwan_Kim 

      My PC's regional settings are set for my local language and region. 

      Are you saying that I have to reset my PC to Russian to get Power Bi to work in Russian? Surely that must be incorrect - I cannot read Cyrillic, so I cannot use my PC if I do that! 😧

      Also the dates are showing incorrectly in PowerBI service, where other GUI texts translate correctly, so I do not see how my PC's settings play a role there.

      CJ

  • CJDK's avatar
    CJDK
    Helper II
    5 years ago

    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.
    3. Merge the new month column and the Year column.

    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.