Renaming categories in bar chart Power BI

[ElizaLi]

Hi Everyone!

I am new to Power BI and have just started a course in Data Analysis. Would really appreciate if someone could help me.

I created a bar chart : Number of accidents vs Month. The months in the table are in numbers e.g. Jan is 1, Feb is 2 etc. So, the categories on the X axis of the bar chart are also numbers but I would like them to be Month names. I tried to find an option in the formatting but there doesn't seem to be one.

I then thought I may need to create a new column with some kind of rule...I tried SWITCH but I'm not sure how to do it for all 12 months...

MonthName= switch(tablename[MONTH], 1,jan,...) ??

Any help would be much appreciated! and apologies if it's a silly question 😞

Thanks, Eli

[amitchandak]

@ElizaLi , if you want that sort column prefer to create that in the power query

if we have date we create a column and sort column

Month = FORMAT([Date],"mmm")

Month sort = month([DAte])

and mark Month sort  as sort column of Month

or create like

Month 1 = [Month]

Month Sort = Switch ( [Month],

"Jan",1,

// add others

)

And mark month sort as sort column for month 1  and use

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c