Filter other chart on 1 dimension but not other dimension, same measure

[ilcaa72]

i have the same measure that i use on a matrix and a bar chart.  On the Matrix i have 2 dimensions, BankID and Date, on the chart I only have 1, Date. 

1 month MatchRate Delta = 
IF(ISBLANK(DATEADD(test[Date],-1,MONTH)),BLANK(),  
CALCULATE(sumx(test,test[MatchedRate]), filter(all(test[Date]), test[Date] = max(test[Date])))
- 
CALCULATE(SUMX(test, MAX(test[MatchedRate])), DATEADD(test[Date],-1,MONTH))
)

I want only show the latest Date on the Matrix (filter show latest date) BUT i dont want that filter on the bar chart, I want to be able to select a BankID on Matrix and show the values over time (not filtered) on the bar chart. 

My question is, do I need to duplicate the measure and add a AllExcept to the barchart, or is there another way to accomplish this...  here is a workbook.  https://1drv.ms/u/s!Av69y58QJYzRjyK7uV29mJleakUo

[v-yulgu-msft · Accepted solution]

Hi @ilcaa72,

Two options for your reference.

1. Add a date slicer. But disable the interaction between slicer and bar chart and table visual.

2. Apply visual level filter for Matrix visual based on date column.

Best regards,

Yuliana Gu

[ilcaa72]

thanks Yuliana

but it only solves 1 of the problems.... when you click a BankID, the bar chart/small table collapse to the Date of the column (filter),  if you notice my first screenshot, i mention that I still want to select a Bank ID, this will allow me to filter the charts for BankID data, but maintain all the dates in the smaller table and barchart...

[v-yulgu-msft]

Hi @ilcaa72,

That case, you need to duplicate the measure and add a AllExcept to the barchart.

Regards,

Yuliana Gu