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

       

      • ghaines's avatar
        ghaines
        Icon for Resolver I rankResolver I
        3 years ago

        The sorting is set up staticly on the whole table, not in the context of your visual.  The problem is that there are multiple values of month_sorting for each Month

         

        e.g. for June, Jun corresponds to 202206 and 202106.  When there are similar multiple values for the other months, it doesn't know how to perform the sort.

         

        Either use Format(..., "MMM") for short month and Format(...,"mm") as your month_sorting
        and always have a year filter in effect where it is used

        or
        use Format(..., "MMM yyyy") for short month and Format (..., "yyyymm") as your month_sorting but this will change your display output.