Can Measure Result be used for Creating a Chart?

Anonymous , One is you need have date table with Month and month year and joined with your date.

You can use stacked line visual

Use Month from date sales trend as a legend.

refer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

Can you share sample data and sample output in table format?

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. 

Hi Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your onedrive business.

Best Regards,

Rico Zhou