Clearing selection of Start Date if End Date is selected

[swrlabhe]

Hi PBI Gurus

I have 2 Date Sliders configured in such way that they just show one date field with calendar to select from.

as below 

So both are End dates but a text box is layered on the start date selection of slider.

Now I want to filter data like start date and end date but if I select Start Date as 13-May-2025 then it should give me data on or before for 13-May-2025 and same way of I select End Date then 21-May-2025, then it should clear off selection from Start Date and then apply End Date selection i.e. on or before for 21-May-2025.

Help Appreciated

[v-pnaroju-msft · Accepted solution]

Hi swrlabhe,

As per my understanding, we have recreated the scenario using a sample dataset and got the expected result.

Here are the main steps we followed:

1. Loaded the input data with TM_ID, Version, and update date.
2. Created a disconnected calendar table using the CALENDAR function for the As of Date slicer.
3. Added a slicer using CalendarTable[Date].
4. Created a dynamic measure ShowLatestAsOf using CALCULATE, FILTER, and MAX to get the latest update date per TM_ID on or before the selected date.
5. Applied this measure as a visual-level filter, set to 1 on the table visual, to show the latest version per TM_ID as of the selected date.

Please find the attached screenshot and the pbix file for reference:

If you find our response helpful, please mark it as the accepted solution. This will help other members in the community with similar questions.

If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi swrlabhe,

As per the previously attached sample PBIX file (Revisedslicerstartandend), we have created two date slicers for Start Date and End Date, respectively.

We need to select the same date in the "StartDate" slicer (for example: 05/15/2025) so that sales data values less than or equal to 05/15/2025 are displayed, as shown in the attached screenshot, without altering the dates selected in the "EndDate" slicer.

Similarly, when a date is selected in the "EndDate" slicer, the sales data values less than or equal to that selected date should be displayed accordingly.

As mentioned earlier, Power BI slicers do not support clearing one slicer based on the selection of another slicer. To address this limitation, we have implemented the approach demonstrated in the attached file.

Should you have any further queries, please feel free to reach out to the Microsoft Fabric Community.

Thank you.

[swrlabhe]

How about if I want only single slicer selection for as of date and all latest values until that date should be displayed

for ex if I have below data 

And I want just as of date filter and reflect latest data as of date as shown below 

[v-pnaroju-msft]

Hi swrlabhe,

Thank you for your follow-up.

Please find attached the screenshots and the revised sample .pbix file for your reference:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who may have similar queries.

Should you have any further questions, please feel free to reach out to the Microsoft Fabric community.

Thank you.

[swrlabhe]

I am not sure it's working as required 

[v-pnaroju-msft]

Thankyou, @Greg_Deckler, for your response.

Hi swrlabhe,

We appreciate your query raised through the Microsoft Fabric Community Forum.

As per my understanding, Power BI slicers do not support clearing one slicer based on the selection made in another slicer. To address this limitation, we have implemented the following approach to achieve the desired outcome:

1. Created disconnected Date Tables for Start and End Date slicers, so that they do not interfere with each other or with the main data.
2. Developed DAX Measures to dynamically identify the selected Start Date or End Date, and apply the appropriate filter without affecting the slicer visuals.
3. Created a final filtering measure (DateFilter) that applies logic such as, if End Date is selected, it will ignore the Start Date; if only Start Date is selected, it will apply it; and if neither is selected, it will display all rows.

Please find the attached screenshot and sample PBIX file for your reference:

We hope the information provided helps in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

[MasonMA]

From @swrlabhe' last post , user seems to prefer Calendar UI. Would this be possible? @v-pnaroju-msft 

[swrlabhe]

Yes can we have this as slider end even if we select Start Date can we display data before start date 

[Greg_Deckler]

@swrlabhe I'm going to think about this one but off the top of my head I can't think of a way to do that natively. If there is a way it might involve bookmarks and buttons.