Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'd like to change the character lengths for the Months like what is below:
The x-axis is dates from the date table. I'm trying to change the length of the months into what is below:
'Jan', 'Feb', 'Mar' etc.
I'm wondering is it possible to do this without creating a new column or table.
Thank you,
Solved! Go to Solution.
Honestly, it is probably just easiest to add a short month name column to your date table.
You don't want to change the default format of your date column as it will effect everything.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
If you really want to change your date column without adding a column, see below.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Firstly I have to say I really like the use of the GIF, looks neat. Honestly, it did cross my mind to don this however I have several other charts and tables where I require the full character length of the month names. As a last resort, is it possible to create....a measure using the code that TheoC kindly provided?
Hi @HamidBee
Easiest way is to create a Calculated Column like this:
Column = LEFT ( Table[MonthName] , 3 )
If you don't want to do a new column, then click on the Month Name field and the three little dots to the right of it. Right Click and go to New Group. Then you can name each month whatever you like 🙂
Hope this helps 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Honestly, it is probably just easiest to add a short month name column to your date table.
You don't want to change the default format of your date column as it will effect everything.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @HamidBee
Easiest way is to create a Calculated Column like this:
Column = LEFT ( Table[MonthName] , 3 )
If you don't want to do a new column, then click on the Month Name field and the three little dots to the right of it. Right Click and go to New Group. Then you can name each month whatever you like 🙂
Hope this helps 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Thank you for your reply. Is it possible to create a measure instead using the code which you provided?
Hi @HamidBee, unfortunately not in this instance that I'm aware. If you're adamant on not wanting a column, then go with the New Group approach. However, as flagged, it would be the most appropriate using the new column.
Note, @KNP has just provided a gif that can give you a solution to what you want by changing the formatting. That is a simple approach as keeps the current structure of your model the same, too. I recommend using @KNP's solution.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
No worries, Thank you for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |