How to show numeric month number on x axis instead of month name from date field

MikeY1975 41 Reputation points
2020-11-13T21:57:46.95+00:00

How do you show the month number on x axis instead of month name from date field on a line chart?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,143 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Matt Allington 332 Reputation points MVP
    2020-11-30T08:37:26.387+00:00

    You create a calendar table including a column for month number, and use that. Read my article here https://exceleratorbi.com.au/power-pivot-calendar-tables/

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.