Excluding some data after a certain date from dashboard

[Jojeh]

Let's say I want to exclude countries a, b, and c, after 01-01-2023 on a dashboard. so, data before that time appears for countries a, b, and c but after that time those countries show blank.

One way is to write it in the query when importing from SQL to power bi, right? but I wanted to know if there are other ways to do that because sometimes there are a lot of tables.

Please let me know if you need more info and thank you for the help!

[JirkaZ]

You could implement this logic in a measure. The question is what would happen if the user chose a date interval say 2022-01-01 until 2024-12-31?

[Jojeh]

The user can only choose FY and it will show each month of that year (Matrix Chart). is there a way to do it on a filter panel?

Also, what would the Measure be considering I have dim_time, dim_location, and the data table with the country name?

[Jojeh]

and if the user chooses 2022-01-01 until 2024-12-31, it has to show the data until 2023-01-01 and the rest blank. 

[JirkaZ]

I think something like this could work:

My Measure := 

SUMX('DimLocation', 
  IF('DimLocation'[Country] in ("Country 1", "Country 2"), 
  CALCULATE(SUM('FactTable'[SalesAmount]), DimDate[Date] < DATE(2023, 1, 1)), 
  SUM('FactTable'[SalesAmount])
)