Combo Chart with Legend

[MWilson929]

Hi,

I'm trying to create a chart as per the following;

1. Current year sales vs Last year sales

2. A line for each per product

With a combo chart I can fulfil the first requirement. However, if I select more than one products I still only get one line per measure. 

With a line chart I can get one line per product for a single measure. However, I can't get a second measure. 

Is there an easy way to do this?

Thanks,

Mark 

[v-shex-msft]

Hi @MWilson929,

>>However, if I select more than one products I still only get one line per measure. 

Current line chart not support to use multiple value field and legend field at same time.

In my opinion, I'd like to suggest you use 'line and clustered column chart'.(drag one measure to column value and another to line value field)

In addition, you can also share this requirement to ideas.

Regards,

Xiaoxin Sheng