cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mg01
Frequent Visitor

Month Slicer always point to Current Month

In report, I have one slicer for Invoice Month, which contains month in format yyyy/mm. Example: 2022/08

Now my requirement is that slicer always point to current month value, let say...
in August 2022 which is current month, 2022/08 must be selected
When i will navigate in Sep 2022, then 2022/09 should got selected automatically.

Is it possible to do so in power bi?

I was able to achieve this by below code:

Invoice Month =
IF (
    'Calendar'[Date] < TODAY (),
    IF (
        MONTH ( 'Calendar'[Date] ) = MONTH ( TODAY () )
            && YEAR ( 'Calendar'[Date] ) = YEAR ( TODAY () ),
        "Current Month",
        YEAR ( 'Calendar'[Date] ) & "/"
            MONTH ( 'Calendar'[Date] )
    )
)

This is approach is fine, but instead of showing text i.e. "Current Month" I want show numeric value to be automatically selected like in current month 2022/08 should be selected, when I will navigate in Sep 2022, then 2022/09 should be selected.
Please find the screenshot below:

mg01_0-1660284092653.png

Thanks,
Mohit Gupta



2 ACCEPTED SOLUTIONS
lukiz84
Solution Sage
Solution Sage

Hi, that's not possible "by default". But there's a little workaround:

Set Default Slicer Selection to Current Year or Month in Power BI - YouTube

View solution in original post

RicoZhou
Community Support
Community Support

Hi @mg01 ,

 

As far as I know, Power BI doesn't support us to set a default selection in slicer. I think add a selection "Current Month" should be a good workaround.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function : Select Default in the Date Slicers
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
RicoZhou
Community Support
Community Support

Hi @mg01 ,

 

As far as I know, Power BI doesn't support us to set a default selection in slicer. I think add a selection "Current Month" should be a good workaround.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function : Select Default in the Date Slicers
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

lukiz84
Solution Sage
Solution Sage

Hi, that's not possible "by default". But there's a little workaround:

Set Default Slicer Selection to Current Year or Month in Power BI - YouTube

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.