Date slicer between Start_End and End_Date (Being End_Date dependant on a dropdown)

[derekmalag]

Hi, I'm trying to apply some filtering in a line chart visual 

I have 2 tables:

1. Period - Includes start date, end date and a id for the period/month 
2. Events - Includes EventID, Date and Period Identifier

Screenshot below of a sample data. Relationship is between 1:1 Period-PeriodId

Then I have the following visual

The line chart should be filtered using the "slicer between" the dates, and the "slicer between" should not have an end date greater than the end date of the Period dropdow. The target scenario is:

• if I selected period 7 (July), y can modify my slicer between 01/01/2021 and 31/07/2021. 
• If I select period 5 (May), I can modify my slicer only between 01/01/2021 and 31/05/2021

My approach so far is:

1. create another table for 'DatesFilter' and a calculated column 'MyValuesColumn' based on the selected value of the dropdown, something like MyValuesColumn= IF('DatesFilter'[End_Date]<=SELECTEDVALUE('period'[End_Date]),1,0)
2. Edit the interactions to make the line chart dependant on Slicer, and the slicer dependant on the dropdown
3. Apply filter to the slicer when MyValuesColumn = 1

This is not working for me as I guess I can use SELECTEDVALUE to make updates to a calculated column. Also I'm not convinced this is the best approach so any idea wwould be really helpful.

Many thanks

[lbendlin]

Familiarize yourself with the way "What if?" parameters work in Power BI.