Measure as a Slicer for a Line Chart

[alearner]

Hello. First of all a thanks to all who are helping me out with the queries that I have in DAX and as such help me train on DAX,

Looking for a solution for a readblocker that I am in. 

I have a table which has the NAV for the last 13+ years. There are Multiple Schemes and the NAV for each day of the year. I also have a Date Table and the Date Table has a relationship with the NAV table. 

The Sample Tables look like below. 

NAV Table:

navDate	navValue	navValueAdjusted	FundHouse	SchemeName
01-01-2013	56.17	56.17	ICICI Prudential Mutual Fund	ICICI Prudential Equity & Debt Fund - Direct Plan - Growth
02-01-2013	56.61	56.61	ICICI Prudential Mutual Fund	ICICI Prudential Equity & Debt Fund - Direct Plan - Growth
03-01-2013	56.8	56.8	ICICI Prudential Mutual Fund	ICICI Prudential Equity & Debt Fund - Direct Plan - Growth
22-11-2023	309.0981	309.0981	SBI Mutual Fund	SBI CONTRA FUND - DIRECT PLAN - GROWTH
23-11-2023	309.1313	309.1313	SBI Mutual Fund	SBI CONTRA FUND - DIRECT PLAN - GROWTH
24-11-2023	309.2942	309.2942	SBI Mutual Fund	SBI CONTRA FUND - DIRECT PLAN - GROWTH

Above is just a sample.

Similarly I have a Date Table also which has the dates. 

I have a line chart which is as below: 

Note currently the slicer that you see of 1, 2 and 5 years are not active and this is something that I am trying to achieve. I could have put in Year slicer but would not like to use that as there would be just too many years to select starting from 2013 to 8th Dec 2023. Depending upon what I select above I would like to go 1 year, 2 or 5 years from the Max date that is present in the NAV Table.

I have created a calculated table which has the value of the slicer. But the challange that I am facing is how do I change the Data of the x axis (Date from Date Table) to show only last 1 year from the current Max date in the NAV table. 

I tried using the below but it is not what I want. I tried for 1 year to check the output:

Selected KPI FOR Landing Page NAV =

    SWITCH('Summary Page SLICER'[Slicer Selected],

        1, CALCULATE(

    SUM(ALL_NAV[navValue]),

    DATESINPERIOD(

        'Date'[Date],

        MAX('Date'[Date]),

        -1,

        YEAR

    ))

and this is what I get. It simply goes back one year from the current year but the year at x axis remains the same.

The sample NAV table with more date can be found at the below link:

https://pastebin.com/edit/0EcLuH32 

[lbendlin]

I have created a calculated table which has the value of the slicer. 

You cannot create a calculated column or calculated table from a measure.  (Well, you can, but it makes no sense).

It needs to be the other way round - your measure needs to sense the selected value of a table (your year buckets) and then the measure needs to ba applied as a filter to the line chart.

[alearner]

I was finally able to achieve what I wanted using the below Measure for 1, 3 and 5 years. Now my chard dynamically changes the x axis as I select 1, 3 and 5 years.

Selected KPI FOR Landing Page NAV =

var maxdt1= CALCULATE(MAX(ALL_NAV[navDate]), all(ALL_NAV)) - 365

var maxdt3= CALCULATE(MAX(ALL_NAV[navDate]), all(ALL_NAV)) - 1095

var maxdt5= CALCULATE(MAX(ALL_NAV[navDate]), all(ALL_NAV)) - 1825

   return SWITCH('Summary Page SLICER'[Slicer Selected],

        1, CALCULATE(sum(ALL_NAV[navValue]), ALL_NAV[navDate] >= maxdt1),

        3, CALCULATE(sum(ALL_NAV[navValue]), ALL_NAV[navDate] >= maxdt3),

        5, CALCULATE(sum(ALL_NAV[navValue]), ALL_NAV[navDate] >= maxdt5),

        sum(ALL_NAV[navValue]))