Forum Discussion

ChrisPBI's avatar
ChrisPBI
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 ...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    ChrisPBI

     

    1. Create a calendar table.
      calendar TABLE = CALENDAR("2001-01-01","2016-12-31")
    2. Map one:many relationship.
    3. Change your measure to
      LastYearAmount = CALCULATE(SUM('GGE Amounts'[GGE in kg CO2e]),PREVIOUSYEAR('calendar TABLE'[Date]))
    4. Done


     

    Check the details in the attached pbix, the unzip password is sent via private message.

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi Patt,

 

Show a dataset, explain the question and show the expected result.

Patt's avatar
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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Share the link from where i can download your file.