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 us...
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:

     

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:

       

      • Br1bn's avatar
        Br1bn
        Regular Visitor
        3 years ago

        The downside of this solution in that now in the tooltip I have also che MonthNumber field when I go over with the mouse

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello Br1bn  after created the new column of abbrv, go to your tables, 

      Create a new sort column

      Sorting = format([date],"yyyymm")

      Now

      Select the added column of abbrv, and press on sort column, and choose the sorting added column

      • Br1bn's avatar
        Br1bn
        Regular Visitor
        3 years ago

        I created a new column:

        Month_Sorting = format(Data[Date],"yyyymm")

        Then I clicked on the column "Month Short" and then I went to "Column Tools":

        but tring sorting by the "Month Sorting" I got this error message