Forum Discussion
Date Filters
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.
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.
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.