- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

X -Axis with Month Names
How can I get the X-axis like below?. I don't want to see full month name like January, February, etc.
Thanks in advance
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Kunder ,
Create a year_month number column based on the month name, then select the month name column, click sort by column button, and select sort by month number.
Year_Month number = Year(Sheet2[Date])*100+MONTH(Sheet2[Date])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Kunder ,
Create a year_month number column based on the month name, then select the month name column, click sort by column button, and select sort by month number.
Year_Month number = Year(Sheet2[Date])*100+MONTH(Sheet2[Date])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Kunder Create a new column like:
Column = LEFT('Table'[Month Name],3)
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Greg_Deckler - I can do that but data doesn't display in sorted order.. Eg: Jan, Feb, Mar, etc.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-22-2025 03:31 AM | |||
07-23-2024 03:32 AM | |||
08-02-2024 06:22 AM | |||
07-31-2024 02:45 AM | |||
10-21-2024 12:10 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |