Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multi line delta value in Line chart

Hi All,

 

  I am working on creating delta value lines in a line chart for the years. In my data model I have year and value as two columns and based on the year selection from the slicer those many lines should come with delta value from previous year in the line chart.

 

e.g. 

   If I select 2020 from slicer then a single line should appear in the line chart of delta value 2020-2019

   If I select 2020 and 2019 from slicer then two lines should appear in the line chart of corresponding delta line of 2020-2019 and 2019-2018.

 

  Any help with respect to DAX here.

 

Thanks,

Sud