Slicer by column

[Anonymous]

Hi,

I have the below table which I can create a line chart from. However I would like a slicer above it where people can select, for example 'Area A' and 'Area C' and they get just the lines for those two areas.

I've tried unpivoting the columns but then I can't get two separate lines on the line chart, can anyone advise please? Thank you!

Week	Area A	Area B	Area C	Area D	Area E	Area F	Area G
1	4	2	4	7	5	22	6
2	7	12	8	11	7	45	12
3	19	14	12	9	13	67	12
4	18	6	7	12	6	49	11

[Payeras_BI · Accepted solution]

Hi Humandoing,

If I understood well you could unpivot your data like this:

And then get the result you want.

Regards,

J. Payeras

[Anonymous]

Thanks so much for your time and reply, that works perfectly. My issue was that I hadn't completed the final step of adding 'attribute' to the legend.

Many thanks

Ryan