Multi trendlines

[Anonymous]

Hello Great Analytics Minds:

Good morning. How can I create multi trandlines in a single visua?

Data:

Description	FY21-Q4	FY22-Q1	FY22-Q2
A	78.40%	88.10%	88.10%
B	78.40%	80.70%	87.50%
C	83.70%	97.00%	96.30%
D	98.70%	93.90%	94.40%
E	94.00%	95.80%	97.70%
F	97.00%		76.80%
G	99.20%	99.20%	99.30%
H	71.20%	89.90%	97.00%
I	99.20%	92.30%	94.00%

Visual I want to see:

Appreciate your help.

Thanks

[Anonymous]

Appreciate your help on my learning process. Thank you. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

What your visual looks like is based on your table. As far as I know, we could only add one column in to Value field in line chart.

Here I suggest you to unpivot your table in Power Query Editor and then you can create a visual like your screenshot.

Select [Description] and Unpivot other Columns.

New table is as below.

Result is as below.

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.