Calendar Table_Version August 2022.txt (19.2 KB)
Hi Experts,
I am using the EDNA code to make this calendar.
Which gives Date Hierarchy that is being used ion the visual.
Now the month name shows full name which i do not want as its taking more space.
I only want to show 3 alphabets month name like, JAN, SEP, OCT, DEC.
How can i do that.
Thank you for your guidance.
I believe that short month is there from the code that you used…states in the date table “Month Short”
Hi Keith,
I am use the Date Hierarchy to put year and month.
So month and names shows full name. like December, September.
How can i resolve it
Don’t use the date hierarchy. Instead use the Year and Month Short columns. Or, if you need the month and year together as single label, use the Month&Year column (I’m not sure if I got that column name right, but there is a column in the Date table that has month and year together.
If you are using the mcode for the EDNA date table
the code is in the mcode. looks like you are not using the date table properly.
this is the code in the mcode as per your txt file.
InsertMonthShort = Table.AddColumn( InsertMonthName, “Month Short”, each Text.Proper( Date.ToText([Date], “MMM”)), type text)
check your date table for “Month Short”
Hello @EnanBahadur
Did the responses above help solve your query?
If not, can you let us know where you’re stuck and what additional assistance you need?
If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION
Thank you
Dear @DaveC thankyou for guidance, i was using Hierarchy that was creating problem.
I used year and short month name and it resolved.
Thank you once again