I get data via DirectQuery and we publish our report our Power BI app, but I provided some dummy data below. We have Product P sales data starting May 2024. We have Product D and Product E sales data starting September 2024. I want the starting date to be dynamic based on the Product Slicer:

1. If the user selects Product D and/or Product E (Product P selected or deselected), the starting date must be September 2024.
2. If the user selects ONLY Product P, then the starting date must be May 2024.

Basically, the starting date of the bar chart must be the most recent (max) date between Product D, Product E, and Product P. (Product D and Product E have the same starting date.)

I was able to make a measure (Sum_Sales) that adds up correctly. However, I need the bar chart start date to change dynamically. There are some months with with NULL/BLANK sales. That is fine and I need that show up as empty (zero) on the chart.

We will implement Product C (and possibly other products) in the future, so the solution should work if we include more products in the future.

Also, it must work when D is selected (and/or E is selected) and P is selected, but SEP through DEC are deselected. Since there is no data for D or E, the starting date must be for P. I was having trouble with this when I was trying to figure something out.

Sum_Sales = 
var _edselected = IF(HASONEVALUE('Table'[PRODUCT])
    &&OR("E" in ALLSELECTED('Table'[PRODUCT]), "D" in ALLSELECTED('Table'[PRODUCT])),
TRUE(), FALSE())

var _eddate = IF(_edselected, "202409", "202405")

RETURN CALCULATE(SUMX('Table', 'Table'[SALES]), 'Table'[YRMO] >= _eddate)+0

Scenario 1. D and/or E selected (P doesn't matter)

Scenario 2. P selected only

Notice that Product E has no sales in JAN and FEB and shows up blank on the chart. Yes, this is desired.

Desired result: D and/or E selected (start the bar chart on the green arrow)

Desired behavior if D (and/or E) is selected, and P is selected, but SEP through DEC are deselected (meaning, when there is no data for D and/or E)

Dummy data (note that YRMO is intended to be TEXT type):

Adding: To be clear, if the user filters out 2024 and selects only 2025 (for example), then the bar chart start should behave like normal. The chart should start on whatever date is the oldest given by the filter, unless it includes the above stated start dates. If the start dates are within the filtered date range, then the start of the bar chart should behave as described above.