• Your date dimension should have a Year attribute.

    Just put the year attribute on one axis and the measure on the other.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP