Hiding the minimum date in the date-between slicer due to an issue with the incorrect drill-through

[Learner27]

Hello Community, 

I'm seeking help regarding my report. 
I have a single table where the requirement is to display data on the main page for a selected date, which is a single date Slicer.
For Example selected Date is 12/12/2023
The measure I'm using

Measure = CALCULATE(Count('Table'[ID]),
FILTER(ALL('Table' [Date]),'Table' [Date] <= MAX('Table' [Date])))

The above measures provide accurate results, and I have many measures, all of which are working perfectly. However, when I attempt to drill through from these measures, it gives me an incorrect count of IDs in the drill-through filter section.

I have observed that the date filter is showing the selected date that we chose on the main page, which is 12/12/2023. However, our measure condition is less than or equal to the selected date.

On the main page, I tried enabling a date range, and in the drill-through page filter section, the date filter is correctly applied as before 12/12/2023, showing the correct result. However, the requirement is to allow only a single date selection on the main page, not a date range.

I've also attempted the following steps:

Placing a text box on the minimum date of the date slicer to hide the minimum date. However, it pops up when trying to select the date in the maximum section, and the text box moves backward.

Hiding is acceptable. Please suggest if you have any ideas on how to hide the minimum date range, and the textbox should not move backward when selecting the date (maximum date in the slicer).

Please help me; it would be greatly appreciated.
@tamerj1 @OwenAuger 

[OwenAuger · Accepted solution]

Hi @Learner27 

With your current approach, try switching on "Maintain layer order" for both the text box and the slicer, then test the published report.

This setting should prevent the objects moving forward/backward when interacting.

Does this fix it for you?

Regards

[Learner27]

Hi @OwenAuger 

That was great; it was so satisfying. Thank you so much, Owen.

I have also tried grouping the textbox, but your solution is much more suitable.

Thanks, Owen. Thanks a ton.