Histogram with missing months

[Br1-981]

Hi,

I'm building a report using a DATA TABLE including a Date for each record.

I've created a CALENDAR TABLE using 

Calendar = CALENDAR(DATE(2019,1,1), DATE(2030,12,31))

and then 

YEAR = YEAR('Calendar'[Date])

MONTH = MONTH('Calendar'[Date])

MONTH_SHORT = FORMAT ( 'Calendar'[Date], "MMM" )

Then I've connected the two tables and I'm trying to create a histogram but the problem is that using MONTH i have the full range across the year:

while using the MONTH_SHORT I got:

But I cannot understand why, my target is to use the MONTH SHORT but havnig the full range.

Thanks in advance 

[ryan_mayu · Accepted solution]

@Br1-981 

have you tried "show items with no data"?