Month - 3 Character abbrevition or short form

[wherdzik]

I would like the months abbreviated to 3 characters so its easier to look at.  I see the service date is getting divided to a hierarchy. Is there a way in options to change it so that I get January to look like Jan, February to look like Feb. Also after doing that, if it requires some sort of a function, is it going to still sequence correctly in the corect order.  Sometimes I know when I try to mess with text functions PowerBI does not realize the sequence of the months. 

Thank you for reading.

[tackytechtom · Accepted solution]

Hi @wherdzik ,

Normally, I would solve this with a separete Date Dimension which is connected to the date attribute of your fact table. Then, in that Date Dimension, I would have all sorts of date related columns showing different formats of that date, i.e. YYYYMM, MMM, yyyy-mm-dd, but also stuff like IsWeekend, SameDayPreviousYear etc. Then all you need to do is to drag in the attribute you need for your Visuals and use case.

Using date dimensions are generally a best practice. Here some links:
Creating a Date Dimension Table in Power BI (mssqltips.com)

How to Create New Dimension Date Table in Power BI - Zebra BI

Hope this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[PijushRoy · Accepted solution]

Hi @wherdzik 

Please create a Lookup table for Month in Power Query as Enter Data

Month_Full_Name	Month_Short_Name	Sort_Order
January	Jan	1
February	Feb	2
March	Mar	3
April	Apr	4
May	May	5
June	Jun	6
July	Jul	7
August	Aug	8
September	Sep	9
October	Oct	10
November	Nov	11
December	Dec	12

2. Update sort order as per your requirement
3. Load the table
4. Select the Month_Short_Name col and change the SORT BY Sort_Order col

5. Create a relationship the existing table with Month_Full_Name col
5. Use the Month_Short_Name col in your visual
Done

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 👍

Thanks
Pijush

Follow www.MyAccountingTricks.com 
Youtube - https://www.youtube.com/channel/UCWWGZXYYq_TmV6UPiC3ujkQ

[tackytechtom · Accepted solution]

Hi @wherdzik ,

Normally, I would solve this with a separete Date Dimension which is connected to the date attribute of your fact table. Then, in that Date Dimension, I would have all sorts of date related columns showing different formats of that date, i.e. YYYYMM, MMM, yyyy-mm-dd, but also stuff like IsWeekend, SameDayPreviousYear etc. Then all you need to do is to drag in the attribute you need for your Visuals and use case.

Using date dimensions are generally a best practice. Here some links:
Creating a Date Dimension Table in Power BI (mssqltips.com)

How to Create New Dimension Date Table in Power BI - Zebra BI

Hope this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/