How to show every month even without data? How to display months as abbreviations?

[Anonymous]

Hi,

I have this issue that I am using the "Show values without data" function but its still not showing every month:

when i do this, every month is shown but as words and I want numbers or short version of the month like Jan, Feb...:

Does somebody know how to display it like that?

[mickey64]

For your reference.

Step 1: I make a calendar table and add 'Year' column and 'Month' column.

    Calendar = CALENDARAUTO()

    Year = YEAR([Date])

    Month = FORMAT([Date],"mmm")

    

Step 2: I make 'Year Hierarchy'.

Step 3: I add a relationship.

Step 4: I use 'Year Hierarchy' to X-axis.

[Anonymous]

Hi mickey,

your result really helped me however I am not using Calendar = CALENDARAUTO() since I have data for certain dates. This data is recognized as a Date tho.

How the Dates are organized in the maintable:

Therefore I am struggeling now to create the hierarchy because the Month and Year are not under the same "calender" they are just random in my main table.

I believe, when they are in a hierarchy they won't let so,e dates out but currently still some month where I don't have data are missing:

but the Months are already in 3digits which I love :3

Does someone know how to hierarchy them?

[mickey64]

How about these options?

Option 1: I change 'Sort axis' of X-axis.

Option 2: I change 'Show items with no data' of X-axis.

You can add the same columns to data table, 'Year' and 'Month' from 'Input Date' column.

[mickey64]

After you create 'Year hieralchy, you can add 'Month' to the 'Year Hierarchy'.

[vanessafvg]

do you have a date column that is of date datatype?

secondly i would suggest using a date table so you can link your date to the date table and get any version of the date field that you need.

here is a video that explains it well

https://www.youtube.com/watch?v=WybnTHDl-AM