Forum Discussion
Date Filtering
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 ...
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.
Hi
Just inseert fields Date and month from of your date Table in the slicer and you will have this view
I tried doing that but the slicer wont have any effects at all to the table, i made sure they are both connected too