Show X-Axis items with no value - Overriding relative date filter

[LPlenty]

I have set my X-axis to show items with no data, as i wish to see all months when filtering by slicer which contains values in only some months. However, it appears to be overiding my relative date filter. It only does this when I apply the "show items with no data" under my date X-Axis.

I have a relative date filter set to show the last 12 calender months only and a date table ending 31/03/2025. 

Any ideas how i can fix this? thanks in advance.

[LPlenty]

Ok it behaves as expected when YearMonthShort used, but not when the date hierachy is?

[LPlenty]

Yes.

[danextian · Accepted solution]

Is that hierarchy automatically generated? It's probably because it's auto or you are using a hierarchy. As a best practice, we disable auto-datetime as that creates an invisible (but still occupies memory) for each date column in the model.

[LPlenty]

Yes its auto-generated, so that must be why. Thank you! Have amended. 

[danextian]

Hi @LPlenty 

The relative date behavior is designed to display only the data points within the selected range. When filtering to the last 12 months, it should include only those months relative to the current date and exclude any data from earlier periods.

[LPlenty]

Yes. That is the behaviour I am expecting, however as you can see from above graphic its also displaying months early in 2024 and later in 2025 which are not within my 12 month relative date filter. Any ideas what could be causing this? My fact table has no dates after March 2025 and my date table is also set to end in March 2025. 

[danextian]

Are you using the date column from the same table in your column chart? or did you use the one from your fact table?

You can see in the image below the relative date filter works just as expected