Percent Change Between Values on Line Chart

[TimNYC]

I've been asked to show % change between years on the following chart. At present there are two lables per X-axis value because there are two years included in my legend. Is it possible to have one lable per X-axis value, and that lable be the % change from 2019 to 2020? Or is there a better way to show this data?

Thank you,

Tim

[v-lili6-msft · Accepted solution]

hi  @TimNYC 

I think the best way is add it into Tooltip of line chart.

and there is another workaround for you refer to:

Step1:

Use combo chart instead of line chart in the report.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

Step2:

Create different measure by year, eg.

2019 = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019))

2020 = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2020))

Step3:

Drag these measures into line values.

Step4:

Create a Percent Change measure like below:

Difference = 
var lastyear=  CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table'[Year]), 'Table'[Year] = MAX ( 'Table'[Year] ) - 1 )
    )
return

DIVIDE(CALCULATE(SUM('Table'[Value]))-lastyear,lastyear,BLANK())

Then drag this measure into column values

Step5:

You could change the color of the column to white and custom the two Y-axis in format.

Result:

and here is sample pbix file, please try it.

Regards,

Lin

[vivran22]

Hello @TimNYC 

I prefer to include such KPIs as Tooltips. It helps in keeping the visual clean.

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn