Forum Discussion

Br1bn's avatar
Br1bn
Regular Visitor
3 years ago
Solved

Month Abbreviation

Hi, in my data I have two fields YEAR and MONTH that I used to create a new column 

Date = DATE (Data[YEAR],Data[MONTH] ,1)

and setting its data type as Date/time I obtain this:

which I used to build different graphs., e.g. 

 

The problem is that I would use the abbreviated month to save space but I cannot find the way, I tried several approached but none of them worked. Could you help me? 

 

Month
Visualization
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Br1bn 

    For chart visuals, you can always add another field to the tooltips and sort with the tooltips field.

    e.g. another column like:

    MonthNumber= FORMAT ( [Date], "MM" )

    like this:

     

7 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi Br1bn 

    try to plot the visual with a calculated column like

    MMM = FORMAT([Date], "mmm")

    or 

    MM = FORMAT([Date], "mm")

    or 

    YY/MM = FORMAT([Date], "yy/mm")

    instead of the month hierarchy.

    • Br1bn's avatar
      Br1bn
      Regular Visitor
      3 years ago

      FreemanZ  The problem is that than the viz is not sorted on month natural order 

       


      😞

      • FreemanZ's avatar
        FreemanZ
        Icon for Super User rankSuper User
        3 years ago

        hi Br1bn 

        For chart visuals, you can always add another field to the tooltips and sort with the tooltips field.

        e.g. another column like:

        MonthNumber= FORMAT ( [Date], "MM" )

        like this: