Forum Discussion
Resolver ICurrent month in Date between slicer
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
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 LearnBest Regards,
Gao
Community Support TeamIf 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
6 Replies
- amitchandak
Super User
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")
)
yakovlolHello 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
Hi yakovlol ,
Try adding a visual filter for current year to that slicer.Best Regards,
Gao
Community Support TeamIf 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
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 LearnBest Regards,
Gao
Community Support TeamIf 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
