Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

Yes, add a calculated column to your table:

IsCurrentMonth = 
    IF (
        YEAR ( Table1[Create Date] ) = YEAR ( TODAY () )
            && MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ),
        "Yes",
        "No"
    )

Then use this column as a page level filter: where IsCurrentMonth = "Yes"