Forum Discussion
Single Date slicer for multiple date columns
Hi,
Please any one help with my requirement.
My requirement is if I choose from a date slicer any date between 01/01/1900 and 13/03/2020 (inclusive) only individualkey 1 record must be shown.
If I select any date between 14/03/2020 and 16/03/2020 (inclusive) only Individualkey 2 must be shown. (no need to show Individualkey 1 record)
If I select any date between 17/03/2020 to 31/12/9999 (inclusive) only Individualkey 3 record must be shown. (no need to show Individualkey 1 record and individualkey 2 record)
Key point is I need to use only end date column to acieve this and one date slicer(user only need to select one date and not dates between like start date end date).
Sample data looks as follows:
Thank you Mariusz and amitchandak for your help. The following blog post helped me to resolve my problem.
https://community.powerbi.com/t5/Desktop/Date-Filter-Filter-by-point-in-time/td-p/474945
4 Replies
Thank you Mariusz and amitchandak for your help. The following blog post helped me to resolve my problem.
https://community.powerbi.com/t5/Desktop/Date-Filter-Filter-by-point-in-time/td-p/474945
Hi Anonymous ,
I'm glad that you solve your issue by yourself and share us the solution of it. Would you please mark your own reply as the solution to help the other members with the same issue find it more quickly.
Best Regards,
Dedmon Dai
Anonymous , refer if my he Blog dealing with start date and end date can help you
