I’m hoping someone can help with this. I’m having a problem displaying a time interval on my pivot chart where there is no data. I am charting orders by week number for each year. As you can see from the attached picture, there are missing week numbers in my chart which I want to fill in. I have a fact table which I’m using for order count, and it is connected in the data model to a date lookup table with one instance of each date from 2012 thru 2020. As you can see from the chart, I’m missing weeks 10, 11, 13-17, 21, 27, etc. There are no orders for those weeks, however, those weeks are in my data table which is connected in the data model. I would like these dates to show up on my chart’s axis. I am doing this in Excel version 2016. Oh, and I have already marked the date table as a date table in PowerPivot.