Add a third line to line chart based on measure

[obriaincian]

Hi All,

I currently have an area chart:

X-Axis: Date

Y-Axis: Measure 1 - Counts the number of products for current month

            Measure 2 - Filter for the date selected via selected value in a slicer and count products per expiry date.

The area chart is working fine with these, but now I'm looking to add another dimention to the Y-Axis.

I want to Filter my dataset for the selectedvalue date selected and then I want to add a year to each cell in the expiry date column and count the products for each date.

Date	Products	Expiry Date
Jan-21	Chicken	11-Jan-22
Jan-21	Duck	15-Feb-22
Feb-21	Ham	30-Jan-22
Feb-21	Chicken	15-Feb-22
Feb-21	Ham	15-Feb-22
Mar-21	Ham	30-Jan-22
Apr-21	Beef	07-Jan-22
Apr-21	Beef	12-Jan-22

e.g. if the SELECTEDVALUE Jan then I want to filter the dataset for Jan data. Then I want to add a year onto each date in the expiry column and then count products for each date.

I assume there's a measure for this but I'm struggling to find a solution at the moment

[MFelix]

Hi @obriaincian ,

When you refer you want to add a year per each value of the expiry date means that for example a value of January 2021 will be on January 2022 is this it?

Believe I'm not understanding your need since if it's like I'm assuming the chart would give you a line exactly like the one you already have since the values would be based on the original date +1. 

Can you please provide more insights on what you need, if possible with an example.

[obriaincian]

@MFelix 

Here is a sample file Sample Dashboard 

What I want to do now is add a year to each expiry date and draw a third line to represent the count of products for this new date (you're right if the count for a particular product was 3 for the 13-jan-21 then the new line will show 3 for 13-jan-22).

Please note this is only sample data and there is no real sense as to what I'm trying to do but this will be helpful with the data I'm working with offline.

Thanks