Forum Discussion
Syndicate_Admin
Administrator
4 years agoFilter closes Power bi desktop
Hello I would like how to apply a filter that always includes the last 4 months
2 Replies
- amitchandak
Super User
Syndicate_Admin , You can create a column in your date table and use that
Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),0) && eomonth([Date],0) >= eomonth(Today(),-3),"Last 4 Month" ,
Format([Date],"MMM-YYYY")
)Set this value as default in your filter
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
- v-jingzhang
Community Support
Hi Anonymous
You can use the relative date filter or slicer to filter the report.
https://docs.microsoft.com/power-bi/visuals/desktop-slicer-filter-date-range
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.