Multi trendlines

Question

Hello Great Analytics Minds:Good morning. How can I create multi trandlines in a single visua?Data:DescriptionFY21-Q4FY22-Q1FY22-Q2A78.40%88.10%88.10%B78.40%80.70%87.50%C83.70%97.00%96.30%D98.70%93.90%94.40%E94.00%95.80%97.70%F97.00%&nbsp;76.80%G99.20%99.20%99.30%H71.20%89.90%97.00%I99.20%92.30%94.00%&nbsp;Visual I want to see:Appreciate your help.Thanks

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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.

&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

Related content

Power BI - Trendline exploration

Trendline needed

Where is the Multi-row card

Formula for trendline

Scatterplot with trendline no available