Date Filtering

[Anonymous]

Hi Power Bi Community, 

I want to create a slicer which gives an option to choose the month in 2022 and the outcome in the table should show the ongoing job in that chosen month. For example, if i were to choose the month March, my table should show the Job A, Job B and Job D as these three jobs are currently ongoing in that month.

This is the table that I have right now:

I want my slicer to look like this:

Thank You! Appreciate all the help i can get!

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

You can try formula like below:

M =
VAR min_ =
    MONTH ( MIN ( 'Table'[Start] ) )
VAR max_ =
    MONTH ( MIN ( 'Table'[End] ) )
VAR sel_month =
    MONTH ( SELECTEDVALUE ( 'Table 2'[Date] ) )
RETURN
    IF ( sel_month < max_ && sel_month >= min_, 1, 0 )

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.

[Anonymous]

Hi

Just inseert fields Date and month from of your date Table in the slicer and you will have this view

[Anonymous]

I tried doing that but the slicer wont have any effects at all to the table, i made sure they are both connected too