Creation of Date range with MIN and MAX and Show filter in powerbi

[aqeel_shaikh]

Hi All,

I have a table with StartDate and EndDate. I want to date as per attached image can you please help, with MIN and MAX date range showing when i filter with Creation Date range (list provided below). Also, i want a show filters option to connect with my date range.

Please note: i don't have a separate calendar table, my date table is part of the original data set. so please advise accordingly if a calendar table need to be created then please advise how to do it.

The date data has been shared below and the image. 

Slicer "Creation Date Range" in the attached image should contains below:
1) Last 30 Days
2) Last 90 Days
3) Last 12 Months
4) 2024
5) 2025 
and so on.....

StartDate	EndDate
28/05/2008
27/11/2004	31/12/2034
27/11/2006	26/11/2016
26/11/2008	31/12/2014
24/07/2008	12/12/2020
20/06/2008
24/05/2005
31/08/2008
06/06/2006	31/12/2013
14/03/2007
04/03/2005	03/03/2017
15/12/2001	01/12/2030
20/11/2005
01/11/2007	01/06/2014
10/12/2004	31/12/2014

[v-menakakota · Accepted solution]

Hi @aqeel_shaikh ,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I have reproduced your scenario in Power BI Desktop using a sample dataset and implemented the logic exactly as described:

• The slicer dynamically drives the Min and Max dates (e.g., for '2024', it's 01-01-2024 to 31-12-2024).
• The table visual is filtered to show only rows where:
  1. StartDate falls within the selected date range.
  2. AND EndDate is either blank or greater than the selected Max Date.

I applied this logic using DAX and filtering with the IsInSelectedRange field, and I am getting the expected output.

In my current dataset, none of the StartDate values fall within 2024, so the final visual shows no rows. This is actually correct and expected behavior based on the logic you’ve outlined.

To help you validate and cross-check the logic, I’m attaching the .pbix file I used during testing.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

Best Regards, 
Menaka.
Community Support Team  

[v-menakakota]

Hi @aqeel_shaikh  , 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @rajendraongole1 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution so that other community members can find it easily. 

Best Regards, 
Menaka.
Community Support Team  

[rajendraongole1]

Hi @aqeel_shaikh  - Please find the attached pbix . i have created few of the measure for slicer selection and date option. hope it helps.

[aqeel_shaikh]

@rajendraongole1 - Thank you for the revert, would you please advise which field can i connect so i can arrived at the desired view.

what i mean here is from Inputdata which field to link with calendar table and datarangeoptions so the date can be selected as dynamic. 

Appreiciate your advise. thanks.

Regards,

[v-menakakota · Accepted solution]

Hi @aqeel_shaikh ,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I have reproduced your scenario in Power BI Desktop using a sample dataset and implemented the logic exactly as described:

• The slicer dynamically drives the Min and Max dates (e.g., for '2024', it's 01-01-2024 to 31-12-2024).
• The table visual is filtered to show only rows where:
  1. StartDate falls within the selected date range.
  2. AND EndDate is either blank or greater than the selected Max Date.

I applied this logic using DAX and filtering with the IsInSelectedRange field, and I am getting the expected output.

In my current dataset, none of the StartDate values fall within 2024, so the final visual shows no rows. This is actually correct and expected behavior based on the logic you’ve outlined.

To help you validate and cross-check the logic, I’m attaching the .pbix file I used during testing.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

Best Regards, 
Menaka.
Community Support Team  

[aqeel_shaikh]

@v-menakakota ; I have checked the file but when i try to filter with the range the Data table doesn't show me the dates which i have selected. for eg: i tried to extend the date range as per my sample data (2008, and all), Min and Max is showing the range but in the "data" which is table in visials there the data is not showing. 

can you tell me what needs to be done here

Thanks

[v-menakakota · Accepted solution]

Hi @aqeel_shaikh  , 

Thanks for reaching out to the Microsoft fabric community forum. 

It looks like when you adjust the date range such as extending it to include data from 2008 the Min and Max dates update correctly, but the table visual still shows no data.

Here’s why this might be happening:
The IsInSelectedRange filter is set up to display rows where:

• The StartDate falls within the selected date range, and

• The EndDate is either blank or after the selected Max date.

If the data in your table doesn’t meet both of these conditions, it won’t show up in the visual.

To fix this:

• Make sure your StartDate values are within the selected date range.

• Check that EndDate values (if not blank) are after the Max date.
  
  If your sample data’s StartDate values are, for example, before 2008 or after 2008, they won’t appear in the table visual.
  
  

  If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.
  Thank you.

[v-menakakota]

Hi @aqeel_shaikh 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you. 

[v-menakakota]

Hi @aqeel_shaikh ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

 
Thank you.