Line Chart - Change the Date Label for something like mmm/YYYY

[Anonymous]

Hello, I was making a line chart and then I figured out that I couldn't find an easy way of formating date in the x-axis for month/year instead of just year as is shown in the graph below. Does anyone know how i can change this?

Any help will be appreciated.

[ppm1 · Accepted solution]

You need to use a date value on your x axis. You can create an EndOfMonth column in your Date table with EOMONTH('Date'[Date], 0) and use that on X. The visual with auto format the x values based on the scale shown. See below with zoom sliders in two positions.

Pat