Auto Limit Page Display To Only those Fiscal Months That Have Data

[THar01]

I've built an executive summary dashboard with various MTD and YTD visuals. Being an executive summary dashboard, there are no slicers or other filters to alter the data in the visuals - just a static display of data for our exec's. The report auto updates daily and pulls in relevant sales data used to build out the visuals. As our fiscal year runs from September 1 to August 31, I'd to limit the data on the page to just those fiscal months that have sales data, then automatically display each new month's worth of sales data as it is pulled in. For example, today the report is only showing data up thru today (March). I'm doing this manually with a page level filter which means I'll have to manually add each new month to the filter. Is there a way to do this automatically by tweaking my MTD/YTD dax measures?  Or maybe some other means?

Thank you.

[amitchandak]

@THar01 , if you only need to select a month you need to create a column like this table and use it

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Use a slicer of filter.

Or create ytd range filter and filter on that

if( [Date]>= date(if(month(Today())<=8, year(today()) -1, year(today()) ) , 9,1) && [Date] <= Today(), "Current FY" , "Other")

[THar01]

Thanks Amit. The request is that there be no slicers or other filtering on the page, just a static display of data where the visuals automatically update with each new month's sales data. That being the case, would I use the second statement you posted? And, if so, where would it go?  And would be a measure or calculated column in my date table?