Forum Discussion
Date Filters
Hi community! I need to filter a date column by a selected value on the report of an other date column, which is a date too.
I´ll be more especific, I have:
*Date Column 1, wich can be filter by the user on the report. User can choose only one value.
*Date Column 2: This is the date column that I need be filtered. I need that it shows only the dates before the selected value in Date Table 1.
How can I solve it? Any idea?
Thanks!
Hi mmazzalay ,
Please create a measure and add it to the filter on the visual.
Measure = IF( MAX('Date Table 2'[Date]) > SELECTEDVALUE('Date Table 1'[Date]), 1, 0 )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi mmazzalay ,
Create 2 slicers one each for your both date columns.
Now click on first date slicer and go to edit interactions and check if the 2nd slicer has filter option enabled.
Once this is done, whenever you select a data range in your 1st date slicer, 2nd slicer will show date range based on the selection.
Something like this:
For setting up edit interactions in Power BI, refer following article:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks,
Pragati
Thank you for your help, but it doesn't solve the issue.
I need that if on the first filter (Date Report) the user select 29/5/2020, the second filter (Periods) only shows the dates after 29/5/2020.
