Current month in Date between slicer

[yakovlol]

Hello Team,

I have an issue and I am not sure that it can be resolved in PowerBI tool, but I want to ask.

So I have a Date between slicers, and I did an additional slicer that checks "Current month"

So it works perfectly, but when unchecking the "Current month" date between slicer back tp 1/1/2022 (this is my date From I have data in the model) 

The question is - is there is any way to do, when I uncgecking the "Current month" the date From is stay on September 1/1/2023 and in the same time will be possibility to choose anothe period in Date between sclicer?

Thank you 

[Anonymous]

Hi @yakovlol ,

Try adding a visual filter for current year to that slicer.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[yakovlol]

Hello @Anonymous thanks for your reply. That sounds good, but it's not actually what is needed. So if I filter for the current year the user won't be able to check the previous year. And the main problem is that users cannot work with filter in panel in the right

[Anonymous · Accepted solution]

Hi @yakovlol ,

I apologize for being late.
Consider creating bookmarks to save these visual filters and switch between them.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Create page and bookmark navigators - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[yakovlol]

In the end, this is what I actually did 

[amitchandak]

@yakovlol , You can have a slicer like below, in place of check box

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

[yakovlol]

Hello @amitchandak thank you for the answer. But this is actually not exactly what I'm looking for.

So the client wants to see exactly this slicer (Between) to filter the needed period, but at the same time, the report automatically should always show the current month. this is exactly what doing than checkbox.

But then i got another request, when the client uncheck the current month he want to see Dates of current month FROM - TO, but with opportynity to filter nedeed period.

But the issue is when you uncheck box, the date between slicer is back to the oldest date in my data model