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 

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