Forum Discussion
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 ...
- 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.
- Create a calendar table.
- 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.
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
The function PREVIOUSYEAR/MONTH and some other timeintelligence functions should be on contiguous, nonrepeating dates.
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.
