Forum Discussion

gwp's avatar
gwp
Advocate II
9 years ago
Solved

Line chart with multiple fields in Legend

In traditional pivot a user can put any number of fields in say the columns of a pivot table. Each of these fields will influence the number of columns shown in the pivot table and will show up in th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi gwp,

 

Based on my test, currently line char/bar chart not support drag multiple fields to legend. These charts' axis and values field support multiple fields.

For your requirement, you can vote below idea:

Ability to use multiple fields on a legend like an Excel pivot chart

 

Regards,

Xiaoxin Sheng

jnickell's avatar
jnickell
Helper V
9 years ago

I already voted for the suggested idea, but I wanted to make sure that I'm correct in thinking this matches the functionality gap I'm seeing.

 

We have a set of data. in a similar format

Date | Week Num | Bills | Receipts

 

This data set runs for two years.


If I have a line chart and use 

Bills as the Values

Week Num as the Axis

Date (Year) as the Legend

I can see a line chart comparing 2016's Bills to 2017.

 

However IF I try to use a line chart to do the following

Bills and Receipts as Values

Week Num as Axis 

I am unable to put Date (year) as the legend which would allow me to have one chart that shows 2016 Bills, 2017 Bills, 2016 Receipts, 2017 Receipts.

 

Does that match the OP's problem?