Date fill not showing on future months in column visualization

Hello, 

I have this dashboard tile that shows a measure broken down by month name and pivoted by year. This is filtered to `Matches (Advanced) “last 2 years”`.

I have no data returning for the months of Jan, Feb, Mar, Nov, Dec.

In the visualization, Looker does show the first null three months and the data in the following months, but stops at October, omitting November and December. Both November and December are showing in the Data section.

8e664ca8-fe40-4bd8-90e6-a6f9dcce05ed.png

Any ideas on how I can force Looker to show all 12 months regardless if there is data? I have tried adding a date filter for “before next year” and the same thing happens. Date-fill is enabled at the dimension level too.

Thank you

0 0 544
0 REPLIES 0
Top Labels in this Space
Top Solution Authors