Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Shanvitha_V
Frequent Visitor

drill through date range didnt fillter selected MAX Date-1

Hi Export Power BI,
I have Date Range slicer 
example:I have selected Date Range 01/01/2023 to 07/01/2023 Then we need display date between 01/01/2023 to 06/01/2023.
because i need always selected MAX date -1
I have create DAX formula 

Value_new = CALCULATE(sum(Tracker[AMount]),DATESBETWEEN(Tracker[DischargeDate],MIN(Tracker[DischargeDate]),MAX(Tracker[DischargeDate])-1))
Its working 100% in summary page.
summary page i am showing column name is: Department    Totalamount
but when i will drill thought  in Details page my date range didnt filetering its showing all records mean 01/01/2023 to 07/01/2023 but drill throught also i need date filter betwen 01/01/2023 to 06/01/2023

Detail page below table date shwoing
PatientID   Dischargedate   admissiondate   col1  col2  col3 col4 col5 col6


but my drill through showing wrong data(betwen 01/01/2023 to 07/012023) but I need display only 01/01/2023 to 06/01/2023

Date range user select dynamic so static.
anybody can help 
Thanks
Shanvitha
2 REPLIES 2
Shanvitha_V
Frequent Visitor

I have tryied but No lock

amitchandak
Super User
Super User

@Shanvitha_V , if your measure was the reason for filter in the visual. You need use same measure in drill report to get the filter passed

 

refer to how terminated employee, which was because of measure is used in drill through

 

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.