How to reduce the options on Date Filter based on dates from a page rather than all dates in Calenda

[fernandoC]

Hello!

I having an odd problem with date filtering. I've created a calendar auto measure to create the calendar. The issue I'm having is that I can't seem to only select the date ranges based on the page I'm currently visualizing. 

For example: 

Page 1: Open Positions / Range: January 20th 2019 to December 31th 2019 = Current result: Seeing dates from Jan 2018 to May 2020
Image 1: Range of dates supposed to be used on the filter. 
Image 2: Theres only open positions on FY19-20, however, the options for FY18-19 and FY17-18 are still coming up (This also happens for months and quarters). Any help would be greatly appreciated. 

If you require additional details please let me know. Best

[v-alq-msft]

Hi, @fernandoC 

It is a normal phenomenon to appear with all selections. You may use a visual level filter to filter the result. CALENDARAUTO automatically finds the minimum and maximum year of all the date columns included across the whole data model, and generates all the dates included between these years.

You can specify a month number as an argument to CALENDARAUTO. If provided, it generates dates from the first day of the following months to the last day of the month indicated as an argument.

I created sample data to test.

Table:

Calendar:

Calendar = CALENDARAUTO(6)

The range of Calendar is from  7/1/2015 to 6/30/2020.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@fernandoC ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[fernandoC]

Hi Amit,

Thanks for your help on this!.

The main problem I'm having is that the date slicer is giving me date ranges that if selected they don't give any data (due to the fact that the date range doesn't exist in that particular set of data, however, it's valid for other tables. 

Example: Filter shows: - FY2017/FY2018 - FY2018/FY2019 -FY2019/2020 (The information on this filter should only show the "FY2019/2020" as it doesn't have any info before that.  I know I can just apply a filter to that slicer and remove the additional options but Im concerned that it's being manually modified and not done automatically and that could be an issue when there's additional date ranges.

 

I would like for the filter only to show the date range of options within that specific table and not the whole range of dates that the calendar has.

Hope it makes sense. 

Any further questions, please let me know. 

Best,