Different lines representing a many filters on one data field

[malonl1]

I have a column with multiple dates ranging from 2017-2018, and one column for revenue. My goal is to create one line for 2017 revenue and one line for 2018 revenue.

How do I do this?

[v-piga-msft · Accepted solution]

Hi @malonl1,

Do you want to create a line chart like below?

If that is your output, you could create two measure to calculate the revenue for 2017 and 2018.

2017 Revenue = CALCULATE(SUM('Table1'[Revenue]),FILTER('Table1',YEAR('Table1'[Date])=2017))

2018 Revenue = CALCULATE(SUM('Table1'[Revenue]),FILTER('Table1',YEAR('Table1'[Date])=2018))

More details, you could have a reference of the attachment below.

If you need additional help, please share some data sample and your desired output.

Best Regards,

Cherry