How to dynamically select current month in Filter for the page

[Anonymous]

Hi,

We have deeloped a dashboard which consists of two pages, first page  is named  " Current month " and  second page is named "Previous months".  In the "Current month" page we have set the filter to the page as shown in screenshot 1 and in "Previous months" page we have set the filter to the page as shown in screenshot 2.  The issue is we have to change the filters manually at the start of every month.  Is there anyway we can set these filters to work dynamically. So that when we are in November 2022 "Current month" page filter should be Month = 01/11/2022 - 30/11/2022 and "Previous months" page filter should be Month is before 01/11/2022.

Request your guidance 

Screenshot 1 :  of filter for Page 1 "Current month"

Screenshot 2 : of filter for page 2 "Previous months"

regards,

dsmitha

[speedramps · Accepted solution]

This is common question from Power Bi novices who fall into the mistakle of adding dates to slicers.

The trouble is that the slicers remembers the data as default date.

So if you create the report on 22/10/22 then default date will stay as 22/10/22 tomorrow, newxt week, next month and even next year.

Never add dates to slicers.  Use offsets instead

Click here to learn about calendars and offsets 

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

[Anonymous]

Hi speedramps,

Thank you for your reply, let me go thru the offset functions and get back to you

regards,

dsmitha

[speedramps]

Thank you @RicoZhou for accepting the solution. Shame @Anonymous does not accept solutions themselves when members take effort to help them. 😉

[Anonymous]

hI speedramps,

Thank you for your guidance by sharing the url, really helped to solve the issue. 

regards,

dsmitha

[Anonymous]

Hi speedramps,

aplogise for the delay, in fact after replying to you i got totally busy with another dashboard  which my LM wanted  on a priority. 

Hopefully i will go thru your suggestion this weekend and respond to your helping hand

regards,

dsmitha