Solved: Month Slicer always point to Current Month

Anonymous · ‎08-11-2022

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:

Thanks,
Mohit Gupta

lukiz84 · ‎08-11-2022

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

Anonymous · ‎08-17-2022

Hi @Anonymous ,

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