Matrix Columns as a union of 2 slicer selections

[Hoping]

I have 3 slicers on the page:

Measure Names Slicer - Multiple measure names can be selected to be displayed as columns in Matrix. Measure names are in a column of an independent disconnected table.

Year Range Slicer (Between setting) - All years in year range are displayed as columns in the Matrix. Year Dimension joins with the Fact table column that also has Year.

Comparison Year (Single selection) - Single selection slicer that denotes which year acts as a baseline for comparison This column is in a table that is disconnected from the fact and other tables in the model.

Matrix Visual:

Rows: A column from the Fact table 

Columns: Measure Slicer Names column and Year Range Slicer Column

Values: Measure which is a SWITCH statement that displays a measure based on the measure slicer selection

Now the problem is, sometimes the year range may not include comparison year, but I want to displays all years in the year range PLUS the comparison year as a column in the matrix visualisation. When the year range includes the comparison year, its all good, but when it does not I want to be able to display it along with other years in the year range. 

How can I achieve this ?  @Greg_Deckler  @amitchandak 

[lbendlin]

So you want to filter, but not really?  How is Power BI supposed to know that? 

Consider using disconnected tables for your slicers and measure filters for your visuals.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...