Forum Discussion
Dynamic filter for current month
Hello everyone, I would like to know if there is any way to create a dynamic page filter so that whenever someone opens my PowerBI web dashboard, all the charts automatically adapt to the current mo...
yeah,
Drag your date to the Filters on to the all pages filters.
change to relative date> Show items when the values is in this month
Anonymous , have a column like this in your date table
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Select this month and save,
make sure is sorted on a column like
Format([Date],"YYYYMM")