Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
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:
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.
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:
The downside of this solution in that now in the tooltip I have also che MonthNumber field when I go over with the mouse
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
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
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.