How to make lifetime Year Start and lifetime Forecast Year to Series in X- axis in a line visual

[Anonymous]

Hello,
I struggle with a dataset as shown below.
Activity table: 

Activity	Unit	FYPeriod	Outcome	Lifetime_Year_Started	Total LifeTime	Lifetime_%_Complete	Lifetime_Year_Forecast	Company
Fuel	teU	FY23/24 P06	P1 fuel retrieved	2016	300	24%	2039	Sema
Fuel	teU	FY23/24 P07	P1 fuel retrieved	2016	259	24%	2039	Sema
Fuel	teU	FY23/24 P05	P1 fuel retrieved	2016	250	24%	2039	Sema
ARD	teU	FY23/24 P07	P2 storage	1983	1906	60%	2033	Sema
ARD	teU	FY23/24 P06	P2 storage	1983	1923	60%	2033	Sema
ARD	teU	FY23/24 P08	P2 storage	1983	1880	61%	2033	Sema
ARD	teU	FY23/24 P09	P2 storage	1983	1849	61%	2033	Sema
ARD	teU	FY23/24 P05	P2 storage	1983	1949	59%	2033	Sema
ARD	teU	FY23/24 P10	P2 storage	1983	1828	62%	2033	Sema
ARD	teU	FY23/24 P11	P2 storage	1983	1813	62%	2033	Sema

This table has a relationship to the datetable on FYPeriod.
what i want to achieve is to visual Total lifetime against year in a line chart and I have Lifettime Year Started and Lifetime Year Forecast base on activity slicer selected
But i need to ensure the x- axis using the Lifettime Year Started and Lifetime Year Forecast.
for example, Activity called ARD has lifetime year start as 1983 and forecast year is 2033, hence, I want to create a line chart to go from 1983 down to current year to the forecast year.
how can I achieve this?

Thanks

[Anonymous]

Hi @Anonymous ,

Please try:

Create a measure:

measure = SUM('Activity'[Total LifeTime])

Just put the year of the date table on the X-axis and the measure on the Y-axis.

If that doesn't solve it, could you please provide me with the pbix file and remember not to log into your own account when you upload it in Power BI Desktop.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

creating measure of TotalLifetime didn't work.
The issue is how can I make the Lifetime Year Start and Lifetime Forecast as a series in X-axis. for P1 fuel retrieved

I don't know how to do that. And this applies to outcome column when selected as a slicer. I can't share pbix. but the data posted on the question is a replica sample