Work with Relative Date Filter

[Anonymous]

Hello Power BI Gurus, 

I am using Filter section's relative date to show visuals with current month's data. Because the relative date filter automatically changes the date range every month, problem that I run into is that first two days of following month.

I want to be able to show the last month's result in the first two days of the current month without my manual intervention changing the filter. Is it possible to do that with Filters without creating the DAX measures/columns? 

For example, today is March 1st. I want to show February result for next two days (March 1 and March 2nd). I do not want to change the filter manually myself but somehow Power BI recognizes that it is first day of the month so it still shows that last month's data.

Please let me know if this makes sense and let me know there are features allows to do so. 

[GilbertQ · Accepted solution]

Hi @Anonymous 

AS far as I know there is no way to do this with the relative date slicer. This is because the relative date slicer always uses the current date.

The only workaround I can think of is to create a column in your date table which would be for the current month, this would be based on the last date you have data for.

In your example the last date you have data for would be 28 Feb 2022, and then new column would still have it set to "Current Month"

Then when new data comes in for 01 Mar 2022, the new could would then move to "Current Month"?

[Anonymous]

@GilbertQ , 

Thank you for your comment. I was trying to avoid creating additional columns or table but I guess it is only way to resolve the issue.