Need Help for the in report visualisation

Power BI
1

Hello Community, I’m here seeking help regarding my Checkup Quality Report. Due to the sensitive nature of the data, I am providing dummy data.

I have a single table where the requirement is to display data on the main page from the minimum date to the selected date, but in the date slicer, it should appear as a single date.

When I navigate to the drill-through page, my count and records are not being calculated correctly (Drill-through from the Blank count column).

I have also attempted to lock the minimum date, but it was not acceptable for the end users. Please provide me with a valid solution that I can implement in my report. Your assistance is highly appreciated.
Test Report.pbix (122.4 KB)

2

Hi @BAIG - In the sample PBIX provided, Date column is in Text format. Can you try changing it to Date format using Power Query. In the Slicer you can use before function. It will return data from Minimum date to the Selected Date in Slicer.

Thanks
Ankit J