Adjust date format X axis for month year

[Anonymous]

Dear All,

I have two Power BI reports. In the first report I do have a line chart, with on the X-axis the month/year format month year (for instance:  'jan 2023'. When I copy this chart into the second Power BI report, the format on the X-axis is changing to year month (e.g. in this case: '2023  January'). How could I maintain the original format (in this example 'jan 2023')?

Thanks in advance for any suggestion.

Kind regards

[rajulshah · Accepted solution]

@Anonymous 

In the second report, you need to change the format of 'Monthyear' column as in the first report.

You can use the following DAX:

MonthYear = FORMAT ( Dates[Date] , " mmm YYYY")

Please let me know if this didn't work.