Format date axis

[badger123]

Please can someone help me with formatting date axis... I've had so much trouble with this. 

Basically I have this chart, which is currently using date hierarchy, month: 

What I am trying to do is keep the chart as above but make the X axis formatted like: Jan 2018, Oct, 2018, Nov 2018 and so on... but when I remove the hierarchy and just do date, the chart looks like this:

Please help !!! 🙂 

[Anonymous · Accepted solution]

Create two columns in the same table as your date like this:

date_display = FORMAT(dimCal[calDate],"mmm YYYY")

date_BOM = EOMONTH(dimCal[calDate],-1) + 1

Set date_display to sort by date_BOM, and use date_display on the x axis of your chart.

The FORMAT statement returns text, and PowerBI has no idea it represents a date, so it will just be sorted alphanumerically. You cannot sort that by the calDate column because there are multiple date values per date_display values. date_BOM ensures you have one date per date_display value which PowerBI will sort according to the calendar.