The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Using a date in the axis of a cluster column chart visualization and want the axis labels to use the 3 character month abbreviations rather than the full month name "Jan, Feb, Mar, etc." rather than "January, February, March. etc." when drilling to that level of the hierarchy.
Do not see any 'out of the box' formatting cards for this and wondering if there's another way to accomplish this.
Any help would be greatly appreciated!
Solved! Go to Solution.
You would likely have to create your own hierarchy which means that you would have to create columns for each of the values created with the auto data hierarchy and then build a custom hierarchy off of those columns.
You can create a calculated column in your data model using a DAX formula of:
3LetterMonth = FORMAT([Date],"MMM")
Really appreciated this one!
Hi @Anonymous,
You can use the following code to format to 3 char month abbreviations:
FORMAT(TableName[Date], "MMM")
Regards,
L.Meijdam
I am familiar with creating an additional column using that syntax, but how do I embed that into the hierarchy of the date being used in the axis of a clustered column chart?
You would likely have to create your own hierarchy which means that you would have to create columns for each of the values created with the auto data hierarchy and then build a custom hierarchy off of those columns.
Power BI loves to make the simplest things more difficult than they need to be
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
41 |