Hello All,
I have used PBI to take an existing Date and apply it to a visual using hierarchies. Currently the dates for the Month show up as their full names (January, February, March). What I would like them to show is their 3 character names (Jan, Feb, Mar). I know I can use DAX to add an additional column that will show this, but I'm hoping for a more elegant solution.
Thank you in advance for any help you can provide.
Crystal
Hi Crystal,
This is a job for the dates table, in that you should have this as a column in your date table. You can either add this column in the model using DAX, or create it with Power Query, assuming your dates table was created using Power Query in the first instance. If not, then add a calculated column using DAX.
Don't forget to also set the 'Sort by'.
Mynda
