@neelesh You could create a calculated column on your date table to identify the Current month. Values of 1 and 0. Use that as the filter where Current Month is 1. Something like Current = IF(MONTH(Table1[Date])=Month(NOW()), 1, 0)
Looking for more Power BI tips, tricks & tools? Check out PowerBI.tipsthe site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
@neelesh As the report author you can save the report with a certain filter set. End users do not have the ability to set their own default filters though.
Looking for more Power BI tips, tricks & tools? Check out PowerBI.tipsthe site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
@neelesh You could create a calculated column on your date table to identify the Current month. Values of 1 and 0. Use that as the filter where Current Month is 1. Something like Current = IF(MONTH(Table1[Date])=Month(NOW()), 1, 0)
Looking for more Power BI tips, tricks & tools? Check out PowerBI.tipsthe site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Helpful resources
Announcements
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
