Solve week end date on x-axis by displaying year month instead weekending

[sandy2112]

I have a bar chart to display the order and shipped amount by the weekend for which I had tried to calculate the weekend by using the power query formulas.

Then pulled the order amount and shipped amount into bar chart on Y-axis and Weekend column on X-axis but I am not able to display like the above screenshot of my chart(Order Amount and Shipped Amount By Week Ending Date).

Can someone help me in doing this.

[sandy2112 · Accepted solution]

Resolved it myself, my Weekending date is in text format, once I had changed it to Date format the Weekending date became the date table. In the column chart instead of considering the date hierarchy option chose the Weekendingdate then it is fine.