Matrix Months Columns showing last year data by default

[DivakarKrishnan]

Dear Team,

I have a matrix table in my report with Months as columns, my table has data for the year 2020 & 2021 Jan.

When I am opening the report, table shows both 2020 & 2021 data. However, I am expecting it should show only 2021 data by default, I am using DATESYTD & DATESMTD functions.

DAX Formula.

1) Net Sales Amount =

var _sum = [SUM of Total Sales Credit] - [SUM of Total Sales Debit]

RETURN
CALCULATE(_sum, DATESYTD('Calendar'[Date]))

2) Net Sales Quantity =

var _sum = [SUM of Total Quantity Credit] - [SUM of Total Quantity Debit]

RETURN

CALCULATE(_sum, DATESYTD('Calendar'[Date]))

3) Sales_TotalMTD = CALCULATE([Net Sales Amount],DATESMTD('Calendar'[Date])) --- Using in my matrix

4) Qty Sold_TotalMTD = CALCULATE([Net Sales Quantity],DATESMTD('Calendar'[Date])) --- Using in my matrix

Can someone please assist on how to show only 2021 values in my matrix by default (only Jan 2021 for now). I can see 2020 data by selecting slicer year.

Thanks

[StefanoGrimaldi]

configure the filter as a single selection option and select 2021, will be the default option selected when openinig, and the filter can be changed by the user, you can put this filter on ther report, or report filter pane, use the single selection option on the filter setting and that should do, for the specific form you saying would say to put it on the filter itself and them configure it with single selection. 

[StefanoGrimaldi]

add a visual filter on the filter pane with the date field, and select the relative type of filter and select the on this year option, this will limit all data in the visual to be only of the current year. 

[DivakarKrishnan]

If i do this then I will not able to see 2020 data.. My requirement is I would like to see 2021 data by default when I am opening the report. For 2020 data, i can see by using slicer values for year...