Power Bi Slicer By Default Current Month

Hi Jilani ，

 

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：Microsoft Idea
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.

 

Here I will show you a workaround to achieve your goal. I think it is better for you to change the data type for columns in 'Date' table like [DateKey]/[Year]/[Month] to whole number,[Date] to date and so on.

Then add an unrelated table for slicer.

Date for Slicer = SUMMARIZE('Date','Date'[Year],'Date'[Month],"YearMonth",[Year]*100+[Month])

Measure:

Filter = 
VAR _SELECTYEARMONTH =
    VALUES ( 'Date for Slicer'[YearMonth] )
RETURN
    IF (
        ISFILTERED ( 'Date for Slicer'[Month] ),
        IF (
            MAX ( 'Date'[Year] ) * 100
                + MAX ( 'Date'[Month] ) IN _SELECTYEARMONTH,
            1,
            0
        ),
        IF (
            MAX ( 'Date'[Year] ) * 100
                + MAX ( 'Date'[Month] )
                = YEAR ( TODAY () ) * 100
                    + MONTH ( TODAY () ),
            1,
            0
        )
    )

Add this measure into visual level filter and set it to show items when value = 1.

 

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.