Filters not works while selecting multiple Period

Hi Anonymous,

I tried to reproduce your scenario on my side using a small sample model and was able to get the expected output. In the PBIX I created a Calendar table with Year, Quarter and Month information and connected it with the fact table using those fields. Then I applied logic so that when multiple Years and Quarters are selected, the calculation always resolves to the latest Year, the latest Quarter within that Year, and the latest Month within that Quarter from the current selection.

With this setup, even if multiple periods like 2025-Q4 and 2026-Q1 are selected, the table visual returns values only for the most recent period instead of aggregating older quarters.

I am attaching the sample PBIX file for reference so you can check how the model behaves and compare it with your setup.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Community Support Team.