Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multilingual Calendar

Hi all,

 

I'm trying to create a Multilingual report in Power BI. So far I already have the following things translated into multiple languages:

  • Tablenames
  • Visual Titles
  • Visual hovers

The only thing left is the Calendar. There are, as far as I know, two ways to create a Calendar. In M (Power Query) and in Dax. Both give me the same output. A date column, and with the date column you can create other columns like a day name, month name, quarter etcetra. This is great, but the only thing is that it doesn't translate the day and month names in Power BI. The original names depend on the Power BI language settings. 

What I want to achive is that when I push the report to a Workspace (in English), and a user logs in with German language settings, the day and month names should change to that language. Right now the only thing thats changing is the date column, but not the day and month names that are calculated with the FORMAT() function. 

 

Is there some way to fix this and create a Mulilingual Calendar based on the language settings of a Power BI user? Also known as the USERCULTURE()..

 

See the picture below what my problem is. I have set the Power BI user language in German. My date column changes the date names to German, but the calculated day or month names do not change.

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak , thank you for your reply. I have seen this video, this is something that I have in mind but I prefer a solution that doesn't require a slicer or filter panel.

      So my question remains, is there no other option for displaying multilingual day and month names other than the video tutorial?

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

        As far as I know, currently the better way to create a multi language report is using a parameter or a slicer in power bi like the video mentioned. You can also refer this simliar video: Multilanguage Multilingual reports in Power BI 

        The build-in calendar in power bi and calcuation could not change with language changes. 

         

        Best Regards,
        Community Support Team _ Yingjie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.