Forum Discussion

Advocate III

10 years ago

Solved

Display Percent Changes alongside a Line Chart

Hello everyone, is it possible to display percent changes alongside a line chart? That is my use case: I would like to display this in the graph ...

Eric_Zhang
10 years ago
ChrisPBI

Create a calendar table.

calendar TABLE = CALENDAR("2001-01-01","2016-12-31")

Map one:many relationship.

Change your measure to

LastYearAmount = CALCULATE(SUM('GGE Amounts'[GGE in kg CO2e]),PREVIOUSYEAR('calendar TABLE'[Date]))

Done

Check the details in the attached pbix, the unzip password is sent via private message.
Environmental Monitoring.zip3.4 MB

Advocate III

10 years ago

Hi Eric,

thank you very much, that works!

But it is not possible without the calender table, right?

Why can't I use my year column for that?

Regards,

Chris

Microsoft Employee

10 years ago

The function PREVIOUSYEAR/MONTH and some other timeintelligence functions should be on contiguous, nonrepeating dates.

Patt
Frequent Visitor
8 years ago
completed line chartDatasetI tried to use the example above to get percent change to calculate for my data and couldn't get it to work for the life of me.
- Ashish_Mathur
  Super User
  8 years ago
  Hi Patt,
  
  Show a dataset, explain the question and show the expected result.
  - Patt
    Frequent Visitor
    8 years ago
    Ashish_Mathur
    
    The data set shows staff levels (each liene and average salary (y-axis) from 2010 to 2017 (x-axis). I would like to show the year on year percent change for salary over the 2010 to 2017 period on the graph. Screenshot of the data and graph are attached. The data used for the line chart are the engineer types, engineer salary and date (dd/mm/yyy).
    
    completed line chartDataset