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 visualizati...
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.

     

  • 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.

       

      • pbiadenhostacc's avatar
        pbiadenhostacc
        New Member
        5 years ago

        Hi Stephen,

        Ok brother . I will try it.

        Thanks A lot.