Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I would be appreciated if you could help me to solve this issue.
What I would like to achieve is "Year and month filter needed to be automatically realize current year and month, and will select year or month filter by itself. We are not gonna select any month. Program must understand today's month and click filter."
As I know there is no way insert measure into filter.
Is there any way of measure or smt to implement that ?
Thanks in advance.
Regards
@kivancc94 , As of now, we can not default based on a measure. You have use a work around
Create a column and save that on This month in slicer
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.