Custom date filter

[rock_stage_user]

can we edit date filter manually in power bi or is there any visual so we can add year month and date manually. in slicer date filter i am not able to edit on after add report on to the server

[v-henryk-mstf · Accepted solution]

Hi @rock_stage_user ,

You can try formula like below:

Filtered Value = 
SWITCH (
    SELECTEDVALUE ( 'Table'[Custom_Filter] ),
    "Last Year",
        CALCULATE (
            SUM ( 'Table (2)'[Value] ),
            FILTER (
                'Table (2)',
                MAX ( 'Table (2)'[Date].[Year] )
                    = ( YEAR ( TODAY () ) - 1 )
            )
        ),
    "This Year",
        CALCULATE (
            SUM ( 'Table (2)'[Value] ),
            FILTER ( 'Table (2)', MAX ( 'Table (2)'[Date].[Year] ) = ( YEAR ( TODAY () ) ) )
        ),
    "Next Year",
        CALCULATE (
            SUM ( 'Table (2)'[Value] ),
            FILTER (
                'Table (2)',
                MAX ( 'Table (2)'[Date].[Year] )
                    = ( YEAR ( TODAY () ) + 1 )
            )
        )
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[johnt75]

Set up a date table, marked as a date table, and you can then use the Year, Month, Day etc columns from the date table in separate slicers.

[rock_stage_user]

in that case user will need to click multiple times need to edit in this filter only