need help in visualzing data in line and clustered column chart

[NandiSU27]

Hi I have a 3 year showing line and clustered colomn chart, columns are shown for 3 years, but i need line to show for current year only.

[NandiSU27]

This worked, thank you

[v-stephen-msft · Accepted solution]

Hi @NandiSU27 ,

You can create a measure for the line to show for current year only. For example,

Measure 2 = CALCULATE(SUM('Table'[Value]),FILTER('Table',YEAR([Date])=YEAR(TODAY())))

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.