Issue when using a visual to filter other visuals

[RingoSun]

Okay so I have this line graph visual above. And basically I am getting the total quantity of Client brand only for each quarter. More specifically, I am only getting the total quantity from the last month of each quarter, so for Q1 I'm only getting the total quantity from March, for Q2 I'm only calculating June, and so on.

It can be seen that in Q1-2021, Client has 220 as its quantity. So if I click on Q1-2021 on the line graph, I expect that in my bar graph visual, the Client brand will only show me 220 as its quantity as well, but that is not the case, the Client brand is showing me 445 quantity

I imagine it's probably getting the total quantity for the whole quarter instead. How do I prevent that and make it follow the line graph quantity instead?

SAMPLE PBIX

[Anonymous · Accepted solution]

Hello

If you put the measure total qty for the first graph it will work