Forum Discussion
Helper IIIMonth - 3 Character abbrevition or short form
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.
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/Hi wherdzik
Please create a Lookup table for Month in Power Query as Enter DataMonth_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 col5. 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
2 Replies
- tackytechtom
Most Valuable Professional
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
Community Champion
Hi wherdzik
Please create a Lookup table for Month in Power Query as Enter DataMonth_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 col5. 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