Can Measure Result be used for Creating a Chart?

Hi Anonymous 

I build two table to have a test.

This year Table:

Last year Table:

Then I use measure to add Last Year Sale into This year table and get sales gap between last year and this year..

Last Year Sales = CALCULATE(SUM('Last year'[Last Year Sale]),FILTER('Last year','Last year'[Date]=MAX('This year'[Date])))

Sales gap = SUM('This year'[This Year Sales])-[Last Year Sales]

It is not supported to use measures into “Legend”. So we need to create a calculated column of Sales Trend. 

Sales Trend = IF('This year'[This Year Sales]>[Last Year Sales],"Savings","Headwinds")

Then we build a stack column chart, result is as below.

Due to I don’t know the value you use to build the line chart, if this reply still couldn’t help you to solve your problem, you may provide me the calculate logic of the line chart and more details about your issue just like share me a screen shot or share your pbix file by onedrive for business.

You can download the pbix file from this link: Can Measure Result be used for Creating a Chart?

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.