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
rohit1991's avatar
rohit1991
Super User
8 months ago

Hii armchairexpert 

 

You can create a dynamic target line using your What-If parameter by returning a value only for years between 2021 and the selected Target Year. For years before 2021 or after the selected year, the measure will return blank.

Try this measure:

Target Line =
VAR SelectedYear = SELECTEDVALUE(TargetYear[TargetYear])
VAR CurrentYear  = MAX('EmissionData'[Year])
RETURN
IF(
    NOT ISBLANK(SelectedYear)
        && CurrentYear >= 2021
        && CurrentYear <= SelectedYear,
    1,   
    BLANK()
)

Add this measure to your line chart as a separate series.
Now the line automatically extends from 2021 up to the chosen year (e.g., 2030) and disappears when a past year is selected.

 

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.