Forum Discussion
Line Chart not plotting measure's entire data
Hi BIUser1998 ,
I filled in the sample data and made up 24 years of data, and the result should be what you want, please check again.
And you can see below, there's no year field in Legend.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi BIUser1998 ,
Thank you for reaching us. As far as I understand, you need a chart to show the year you currently selected, and the previous year. Then you should modify the measure to:
Previous Year = VAR SelectedYear = SELECTEDVALUE('Values'[Year], BLANK())-1
RETURN
CALCULATE(SUM('Values'[Value]),FILTER(ALLEXCEPT('Values','Values'[Month]),[Year]=SelectedYear))
You can download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , thank you for your reply.
I need it to look something like this
Unfortunately, because I'm using data from other tables as well on this particular chart, I cannot just drag the Year field into legend to get a breakdown of year which is why I'm resorting to creating two measures with the data available. Thank you for your help
Hi BIUser1998 ,
I filled in the sample data and made up 24 years of data, and the result should be what you want, please check again.
And you can see below, there's no year field in Legend.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.