Need to create drill through report from card view for a selected date

[Kusaadigarla01]

Hi,

We have created card views for the previous quarter, current quarter, and the month (selected date’s month) measures based on the selected date from the calendar date slicer using DAX queries. However, we are facing issues displaying the same in drillthrough pages.

When I use the same measure in the drillthrough page, the single-date slicer is being applied as a drillthrough filter, causing the page to show all date values irrespective of the filters used in the measures. This results in the same value being displayed for all rows, and other measures on the drillthrough page appear blank.

Please help in this issue.

Regards,

Kusa

[v-saisrao-msft]

Hi @Kusaadigarla01,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @Kusaadigarla01,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[HarishKM]

@Kusaadigarla01 Hey,
I will flow bellow steps 

Steps - 1) In one of my scenarios, my logic prevented the drillthrough filters from applying to certain visuals by using KEEPFILTERS in your DAX queries to maintain the filter context you desire.

2) Instead of relying on drillthrough, synchronize the slicers across pages, which sometimes helps retain the filter logic you need.

3) If feasible, move some of the measure calculations into calculated columns that lock in filter criteria so they remain stable across page interactions.

example  QuarterlySales = CALCULATE( SUM(Sales[SalesAmount]), FILTER( Sales, FORMAT(Sales[SalesDate], "YYYYQ") = Sales[QuarterKey] ) )

If you follow above steps. That my can help you in this.

Thanks

Harish M

Kudos will be appriciated and accpet it as solution if it solves your problem

[v-saisrao-msft]

Hi @Kusaadigarla01,

Have you had a chance to review the solution we shared by @Abhilash_P @jaineshp ? If the issue persists, feel free to reply so we can help further.

Thank you.

[Kusaadigarla01]

Hi, that was really helped me, but I was still facing the same issue with the grand total and slicers. I cannot create more calculated fields for all objects as the report is getting slow.

So, I am trying to perform major calculations in SQL itself. I need to create calculated fields for previous quarter identification for selected date in power bi as i can not do it in sql. this may use for all remaing card views for filtering.

[v-saisrao-msft · Accepted solution]

Hi @Kusaadigarla01,

Thank you for the update.

Switching to SQL for initial calculations is a good idea, as it can help reduce load on Power BI.

In your situation, using a single-date slicer as a drill-through filter overrides the broader date logic in your DAX measures, which leads to uniform values across rows and blank visuals due to incompatible filter context.

To resolve this, you can try the measures suggested by @jaineshp, which may be helpful.

Thank you.

[Abhilash_P]

Hi @Kusaadigarla01 ,

The issue happens because when you drill through from your card, Power BI passes the exact single date from your slicer to the drillthrough page. This ignores your “previous quarter/current quarter/selected month” logic and forces all visuals to use just that one date. That’s why values look the same or go blank.

You can fix it in these ways:

1. Don’t pass the date as a drillthrough filter – remove the Date field from the drillthrough filters pane or turn off Keep all filters. Pass another field instead.

2. Make your measures ignore the drillthrough date filter – use REMOVEFILTERS() or ALL() in your DAX so the measure uses your own date range logic, not the single date.

3. Use a disconnected date table – create a separate date table for picking the “as of” date and write your measures to use it. That way, the slicer on the main page doesn’t interfere.

Single-date drillthrough filter is overriding your DAX logic. Remove it or make your measures ignore it so the drillthrough page shows the right period

[jaineshp]

Hey @Kusaadigarla01,

I've encountered this exact scenario before and here's what worked for me:

Root Cause: The drillthrough page is inheriting the single date filter from your source visual, which conflicts with your quarterly/monthly measures that need broader date ranges to calculate properly.

Recommended Approach:

1. Modify Your Existing DAX Measures Add REMOVEFILTERS() to your current measures specifically for drillthrough context:

Previous Quarter (Drillthrough) =
VAR SelectedDate = SELECTEDVALUE('Date Table'[Date])
RETURN
IF(
NOT ISBLANK(SelectedDate),
CALCULATE(
[Your Base Measure],
REMOVEFILTERS('Date Table'[Date]),
DATESINPERIOD('Date Table'[Date],
STARTOFQUARTER(DATEADD(SelectedDate,-1,QUARTER)),
1, QUARTER)
),
BLANK()
)

2. Create Separate Drillthrough Measures Don't reuse your card view measures directly. Build dedicated versions that handle the filter context properly for detail rows.

3. Drillthrough Page Configuration

• Remove the date field from drillthrough filters in the page settings
• Keep only the dimensions you need for row-by-row breakdown
• Use your modified measures in the visual

4. Testing Strategy

• Start with one measure and verify it shows different values across rows
• Add other measures incrementally
• Check that totals match your original card values

5. Alternative if Above Doesn't Work Use ALLEXCEPT() to preserve other filter contexts while removing date filters:

Current Month (Drillthrough) =
CALCULATE(
[Base Measure],
ALLEXCEPT('Date Table', 'Date Table'[Year], 'Date Table'[Month]),
'Date Table'[Date] <= MAX('Date Table'[Date])
)

This approach has resolved similar issues in my previous implementations. The key is breaking the inherited date filter while maintaining the time logic your business requirements need.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer