Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
beginner
Helper I
Helper I

How to visualize Months as J F M.... ?

my table look like this 

Month|Monthno|Value

Jan|1|100

Feb|2|200

........

 

 

I want to visualize this as J F M... in the graph by respecting the values for each month in a YTD format sorted J F M format. How do I do this? Btw, I only have the current year values so it won't be confused by any other years. 

2 REPLIES 2
Mageto
New Member

You will have to create two calculated columns for this:

1 - Column Month(m) or anything then use the formula =left(table[month],1) to get the first letter of the month.

2 - Column Month(#) to get the month number, this will help you while sorting your Month(m) axis in a chart.

      in the column, type/use this formula.

Month(#) =
SWITCH(
    Sales[Month],
    "January", 1,
    "February", 2,
    "March", 3,
    "April", 4,
    "May", 5,
    "June", 6,
    "July", 7,
    "August", 8,
    "September", 9,
    "October", 10,
    "November", 11,
    "December", 12,
    BLANK()
)
The next thing would be selecting the Month(m) column while in table view, then under column tools, press on sort by column.
A drop down of all the columns will appear then select Month(#). This will ensure that on chart sorting by Month(m) the months will be sorted 1-12 or 12-1.
I hope this helps you out!
lbendlin
Super User
Super User

While it is possible to use custom date formats

 

lbendlin_0-1695949073481.png

they don't seem to be including a "single letter month"  option.  There are alternatives like this one

Single-letter day and month names in Power BI – XXL BI

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors