cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

How to abbreviate the months on the X-axis of a bar chart?

Hey guys,

 

Short question. is there a way where I can tell powerbi so shorten these labels to the first 3 lettes? Because they don't really fit properly and I there is no space to make the chart wider. I also tried changing the date format but that doesn't work.

 

Thanks!

 

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Post Prodigy
Post Prodigy

Re: How to abbreviate the months on the X-axis of a bar chart?

@ErikBI 

As @Greg_Deckler mentions, you can hold click and drag fields on top of each other to create an hierarchy (you must have done it by mistake once, I have 😁 ). This can also be done for non date fields like product class/ group combinations. For a custom date hierarchy, it would look like this (red box):

 

Untitled.png

View solution in original post

7 REPLIES 7
Highlighted
Super User IX
Super User IX

Re: How to abbreviate the months on the X-axis of a bar chart?

I believe it is FORMAT([Date],"mmm")


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Post Prodigy
Post Prodigy

Re: How to abbreviate the months on the X-axis of a bar chart?

@Greg_Deckler 

@ErikBI 

 

From my notes:

 

General numberNo format
CurrencyAs a price value
Fixed2 decimal no thousand seperator
Standard2 decimal with thousand seperator
Percentpercentage of the number
ScientificScientific notification with 2 decimals
Yes/No0 = No, Rest = Yes
True/False0 = False, Rest = True
On/Off0 = off, Rest is on
  
General dateShort date + long time
Long Datewednesday, march 12 20018
Medium Datewednesday, march 12 20018
Short Datemm/dd/yyyy
Long time12 hours + seconds
Medium time12 hours
Short time24 hours
  
mmmonth number
mmmMonth short
mmmmMonth long
yyyy/mmyear / month number
yyyy/mmmyear + month short
QQuarter
dddDay of week short
ddddDay of week 
  
####Value to text
Highlighted
Community Support
Community Support

Re: How to abbreviate the months on the X-axis of a bar chart?

HI @ErikBI,

I'd like to suggest you extract month field to a new column with format function or try to configure fields formatting in table properties:

17.png

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Helper III
Helper III

Re: How to abbreviate the months on the X-axis of a bar chart?

@v-shex-msft @DouweMeer @Greg_Deckler 

 

I tried your solutions, and they work to a certain degree.

But sadly It doesn't work when I format the axis to use date hierachy. I really like this because it looks cool when the year numbers are listed below the months, and not mentioned after each month.

 

I guess the only option that remains is to just make the graph wider.

But still, thanks for your suggestions!

 

 

 

 

Highlighted
Super User IX
Super User IX

Re: How to abbreviate the months on the X-axis of a bar chart?

If you want a date hierarchy of your own formatted styles, just create multiple columns in your table that have the formatting that you want. Then you can drag and drop these columns into a hiearchy for your axis.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Post Prodigy
Post Prodigy

Re: How to abbreviate the months on the X-axis of a bar chart?

@ErikBI 

As @Greg_Deckler mentions, you can hold click and drag fields on top of each other to create an hierarchy (you must have done it by mistake once, I have 😁 ). This can also be done for non date fields like product class/ group combinations. For a custom date hierarchy, it would look like this (red box):

 

Untitled.png

View solution in original post

Highlighted
Helper III
Helper III

Re: How to abbreviate the months on the X-axis of a bar chart?

Aah yeah. I've accidentillly created those more than I'd like to admit 😄

 

Thanks to you and @Greg_Deckler 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors