Forum Discussion

armchairexpert's avatar
armchairexpert
Helper III
8 months ago
Solved

Target Line Based on What-If Parameter

Hi,   I have a line chart with test Carbon Emission data from 2021 to 2025 in my Power BI report. The objective is to go carbon neutral by 2050.   I want to show a target line on the line chart. ...
Need Help
armchairexpert's avatar
armchairexpert
Helper III
8 months ago

Hi rohit1991 

 

Thanks for your response.

 

That showed a straight line. Let me try to explain further.

 

I have a 'Start CO2 Emission' value of 50.99 for January 2021.

 

 

Start CO2 Emission =
CALCULATE (
    [Total CO2 Emission],
    'Calendar'[Year] = 2021,
    'Calendar'[Month Number] = 1
)
 
So the line should start from 50.99 as per the test data and then gradually become zero for the year the user selects.
 

Thanks.

rohit1991's avatar
rohit1991
Super User
8 months ago

Hii armchairexpert 

 

Please check the complete step-by-step example in the link below. It shows how to start the target line from your 2021 CO₂ value and then gradually decrease it to zero based on the selected Target Year:

https://netorgft12209796-my.sharepoint.com/personal/rohit91_oxygenbi_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Frohit91%5Foxygenbi%5Fcom%2FDocuments%2FForums%2FTargetYear%2Epbix&parent=%2Fpersonal%2Frohit91%5Foxygenbi%5Fcom%2FDocuments%2FForums&ga=1