Forum Discussion

Br1-981's avatar
Br1-981
Helper I
2 years ago
Solved

Histogram with missing months

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 

1 Reply