line & clustered visualization help

[josebernaldez]

Hi, this is my first post, Im using the line and clustered visualization to present in the colums the total sales 2015 & 2016 and the line is for the % profit but its calculated based on both years. 

My cuestion is, how can i graph the % value just for 2016?

Thanks in advance for your support

[v-qiuyu-msft · Accepted solution]

Hi @josebernaldez,

To display line values only in 2016 year, you can create a measure to filter values in year 2016 like below:

Profit2016 = CALCULATE(SUM(Table1[Profit]),FILTER('Table1',YEAR('Table1'[Date])=2016))

Best Regards,
Qiuyun Yu