Forum Discussion
ChrisPBI
Advocate III
Advocate IIIDisplay 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.
Eric_Zhang
Microsoft Employee
Microsoft Employee
- 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.
ChrisPBIAdvocate III
Advocate IIIHi 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
- Eric_Zhang
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.
- Ashish_Mathur
Super User
