Matrix chart dates without affecting chart dates

[Creative_tree88]

Hi all - I have a matrix chart which I have restricted using a filter to show patient clinics in the next 30 days.  However, I also have a chart which is based on the same data and which is showing the same data but historical as well as present and next 30 days (complete date range) .

I'd like to be able for users to click on one of the clinics in the matrix and for the chart to change but to NOT be limited to date range.  At the moment, because the two are obviously linked, when I click on a clinic the chart shows only those dates in the next 30 days which makes the chart very limited in it's purpose of giving the user an idea of historical trends as well.  

Is there a way of being able to click on a clinic, for the chart to show ALL dates but the matrix to stay showing just the next 30 days?  The data in the matrix is useful but far too much if it shows the whole year!!  Thanks.

[v-dineshya]

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.

[v-dineshya]

Hi @Creative_tree88 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and consider giving a KUDOS. Feel free to reach out if you need further assistance.

Regards,
Dinesh

[v-dineshya]

Hi @Creative_tree88 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and consider giving a KUDOS. Feel free to reach out if you need further assistance.

Regards,

Dinesh

[v-dineshya]

Hi @Creative_tree88 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and consider giving a KUDOS. Feel free to reach out if you need further assistance.

Regards,

Dinesh

[v-dineshya]

Hi @Creative_tree88 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

Regards,

Dinesh

[Ashish_Mathur]

Hi,

Please read up on "Edit Interactions".  May be that helps.

[parry2k]

@Creative_tree88 it will be easier to provide a solution if you can share sample pbix file using one drive/google drive. make sure to remove sensitive information before sharing.