Forum Discussion
Comparing years in line graph
I saw a previous message that was similar to this, but I could not figure out how to get the answer to work at all. I have a dashboard I have made in Excel using a pivot chart from a pivot table....
Hi josephmwood ,
take a look at the attached PBIX file.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
DAX measures are an option I guess but it should be noted that this is not a very dynamic solution as a new measure would need to be added every year.
Also, I think the X axis having year included is misleading in this scenario.