Forum Discussion
Line Chart - Change the Date Label for something like mmm/YYYY
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.
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
1 Reply
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