Forum Discussion

pbiadenhostacc's avatar
pbiadenhostacc
New Member
5 years ago
Solved

Arabic months name

Hi bros

I am using a Arabic data and when use date.month as a field in slicer visualization shows the name in Arabic language as i want

But when I use JUST date as the a field in slicer visualization to get months under years , the name of months change to english and I need to show the moths name in Arabic 

please help me to solve this!!

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi pbiadenhostacc ,

     

    I'm sorry that the formula I gave is wrong.

    The reason for the error is because FORMAT returns a text format, and the SWITCH below judges that the 1 in Month_Name = 1 is a number type.

     

    This is the new calculated column I tested.

    Column = 
VAR Month_Name =
    FORMAT ( [Date], "mm" )
RETURN
    SWITCH (
        TRUE (),
        Month_Name = "01", "كانون الثاني",
        Month_Name = "02", "شهر فبراير",
        Month_Name = "03", "مارس",
        Month_Name = "04", "أبريل",
        Month_Name = "05", "مايو",
        Month_Name = "06", "يونيو",
        Month_Name = "07", "يوليو",
        Month_Name = "08", "أغسطس",
        Month_Name = "09", "سبتمبر",
        Month_Name = "10", "اكتوبر",
        Month_Name = "11", "شهر نوفمبر",
        Month_Name = "12", "ديسمبر"
    )

     

    You can check more details from here.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

8 Replies

    • pbiadenhostacc's avatar
      pbiadenhostacc
      New Member
      5 years ago

      Hi Stephen,

      I already changed language of the Power BI Service , Internet explorer and my pc but still when I use date field (NOT date.month) , The name of month shows In English.

       

      Thanks for responding!!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi pbiadenhostacc ,

         

        You may try to create one calculated column to replace the old column with same name.

         

         

        Column =

        var Month_Name = FORMAT( 'date_field'[date] "mm" )

        RETURN SWITCH( TRUE(),

        Month_Name=1, "كانون الثاني"

        Month_Name=2,"شهر فبراير"

        .

        .

        etc

        )

         

         

         

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.