Forum Discussion
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. I want to parameterise the Target Year. So when the user selects a year on the parameter, on the chart it will dynamically show the target line between 2021 and the year the user selected. For example if the user selects 2030 on the parameter, the line should show between 2021 and 2030 so that the user will know we are reaching the CO2 target.
If the user selects a year in the past, then it should show blank.
Can someone please help me create a measure for the target line? I am trying to attach my .pbix file but not sure how to do that as it allows only photos and videos.
Thanks for your help.
7 Replies
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.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.
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:
