How to exclude current month from default month selection in bar-chart

[spagad6263]

Hi,

Our financial year start from Apr and in below comparison chart (current year vs previous year), I would like to exclude current month (Feb 2024). Can someone give some suggestions? 

The YearMonth is a field in dim_Date table.

Thanks

[spagad6263]

Thanks for the quick reply. Will give it a go.

[Ahmedx]

Sample PBIX file attached

[Ahmedx · Accepted solution]

pls try this