Power BI Monthly Report

[GTaylor1959]

 Hi can anyone help please?

I have a cancellation database with the date field Date of Cancellation.  I have added 2 custom columns relative month and month year but my data which starts in September 24 is showing on the graph as Sep24, Oct 24, Nov 24, Jan 25 then Dec 24.

I have sorted the relative month ascending, have MonthYear in the X-axis and count of Date of Cancellation in the Y-axis.  As you can tell I am new to PowerBI and tried all ways to fix it so can anyone help to let me know where I am going wrong.

Thanks

[GTaylor1959 · Accepted solution]

Hi thanks for replying.  I have fixed the problem by sorting on a different column.

[danextian]

hi @GTaylor1959 

As always, please provide a workable sample data (not an image), your expected result from the same sample data and the reasoning behind. You may post a link to a sanitized copy of your pbix or to an Excel file stored in the cloud.