FIlter sync between visuals

[Rudyi]

Hi all,

I have 2 visuals - a matrix and power kpi built over a dataset (category, date, amount of sales).

I've built the matrix to show sum of sales for categories on last date, by filtering TOP1 by Date.

The issue is - if I click on the category, it filters it out in power KPI (which is good), but it also applied TOP1 by date filter, which makes powerkpi a useless dot. 

Is there posibility to sync only 1 filter between visuals? Or other way maybe to buld the matrix to show only sums for last date?

I tried the "Edit iterractions", but that allows only to switch them off generally...

Thanks for any advise!

[amitchandak · Accepted solution]

@Rudyi 

Create a measure with the Top1 filter. and use in matrix

Refer: https://community.powerbi.com/t5/Desktop/How-to-calculate-top-10-highest-in-the-table-and-also-ranki...