Matrix chart dates without affecting chart dates

Hi Creative_tree88 ,

Thank you for reaching out to the Microsoft Fabric Community forum.

can you please follow these steps:

1. Apply the Date Filter to the Matrix Only
Go to your Filters pane. Apply the "Next 30 Days" filter either on the matrix visual or as a visual-level filter, not page/report level. This way, it limits only the matrix, not the entire page.

2. Modify Visual Interactions
Click on the matrix visual to select it. In the toolbar, go to "Format" > "Edit interactions". Small filter icons will appear on all other visuals. On the chart visual, change the interaction to "Filter" or "Highlight" based on what you want—but this is key: Ensure that only the clinic selection is passed to the chart, not the matrix’s date filter.

If the chart is being affected by the matrix’s visual-level date filter, this won’t be passed by interaction, so you’re good.

3. Handle with DAX
If visual filters aren’t giving full control, you could:

Create a clinic slicer or disconnected table.

Use DAX measures with CALCULATE() and ALL() or REMOVEFILTERS() to ignore the date filter in chart-specific measures.

DAX:

ChartMeasure :=
CALCULATE(
SUM(PatientData[Visits]),
REMOVEFILTERS(PatientData[Date])
)
This measure will ignore any date filter—great for the chart showing full trend data.

I trust this information proves useful. If it does, kindly “Accept as solution” and give it a 'Kudos' to help others locate it easily.
Thank you.