Change date format on an Area Chart

[asbpowerbi]

Hello,

  I have an Area Chart. On the x-axis I am using the Month and day from a date heirarchy column. The month format is displaying the whole month name, and I want it to display in mm/dd format. I changed the format of the data column, but that does nothing. How do I change the format so that it is in mm/dd rather than month name day format?

Cheers,

Peter

[Aburar_123]

Hi @asbpowerbi 

Pls use like this

[123abc]

To change the date format on the x-axis of an Area Chart in a Power BI report from displaying the whole month name to "mm/dd" format, you can follow these steps:

1. Select the Area Chart on your report canvas to make sure it's active.

2. In the "Fields" pane on the right side, find the field you're using for the x-axis (the date hierarchy column).

3. Click the drop-down arrow next to the field name to open its options.

4. Under "Date Format," you should see an option like "Automatic." Click on it to open the dropdown.

5. Choose "Custom."

6. In the "Custom date format" input box, enter "MM/dd" (without quotes).

7. Press Enter or click away to apply the new date format.

Your x-axis labels should now display the dates in "mm/dd" format instead of the whole month name. If you don't see the changes immediately, try refreshing the visual or report to see the updated format.

[asbpowerbi]

Hello - Thank you for the fast reply. When I click the drop down arrow, I do not have a format option. I have included a screen image below:

Not sure what I doing wrong.