Show limited time period - relative date filter not working

[atoms_voyage]

I'm trying to get the following visual to show values between July 2022 and today, including all the months in between that don't have any data

The date filters don't seem to do anything. This seems like a super simple use case - it's really frustrating how difficult this is! Please can someone help? Relative date filters don't seem to do anything

[atoms_voyage]

I think I've solved this by adding a date table with a new "Year-Month" column, as well as an additional sort column and then manually filtering the "Year-Months" that I want to see. Seems like a really clunky solution though and which will also require me to manually change the filter when I get new data. Is there really no simpler way to do this? I'm amazed that this isn't a common use case in PowerBI

[Prateek97]

Hi @atoms_voyage ,

Have you enabled the Show items with No Data option on the XAxis Month column. If yes, please disable it and check. 

Otherwise you can try creating a calculated column in the table where your date is present. Something Like this:

Flag = IF([Date]>DATE(2022,7,1),1,0)

Then use this flag as a visual on the filter and select '1' as a value.

Please let me know if this works.

Request you to mark this reply as the solution if it solved your problem.

[atoms_voyage]

I have show items with no data checked. If I uncheck it then I lose March and June 2023 which have no data but which I want to show.

Every row in my table has a date, and the date is always (by definition) greater or equal than the minimum date so the flag you suggest will always be true and won't filter anything out.

[amitchandak]

@atoms_voyage , Make sure you are using a date table joined with the date of your table. Try a measure like

0 between range
Measure = var _1= [Your Measure] +0
var _min = eomonth(today(), -13)+1
var _max = today()
return
if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1)

[atoms_voyage]

I've added a date table to my model, but now my visual looks like this: