Forum Discussion
Set a different filter by default every month?
I have a complete DimDate table and I want to force, that whenever a user opens the report, he gets current month selected in the filters:
How can I achieve that?
So, on May 1st, the selection should automatically be changed to FY22 – 12 – May by default… Also, the user should be allowed to freely change the month, so I can't really force a hidden filter on current month, because I want to allow the user to be able to change it.
On June 1st, it should automatically change to FY23 - 01 - Jun and so on....
Hi Anonymous ,
Please check this post Solved: Filter setting default on current week/month - Microsoft Power BI Community
You can add a column to your date table along these lines.
Week = VAR _Today = TODAY() RETURN IF ( YEAR ( [Date] ) = YEAR ( _Today ) && WEEKNUM ( [Date] ) = WEEKNUM ( _Today ), "Current Week", ***** whatever you normally show for month/week goes here ***** )Regards,
Ritesh
Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My YT Channel Dancing with Data !! Connect on Linkedin || Power BI for Tableau Users
1 Reply
Hi Anonymous ,
Please check this post Solved: Filter setting default on current week/month - Microsoft Power BI Community
You can add a column to your date table along these lines.
Week = VAR _Today = TODAY() RETURN IF ( YEAR ( [Date] ) = YEAR ( _Today ) && WEEKNUM ( [Date] ) = WEEKNUM ( _Today ), "Current Week", ***** whatever you normally show for month/week goes here ***** )Regards,
Ritesh
Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My YT Channel Dancing with Data !! Connect on Linkedin || Power BI for Tableau Users