Forum Discussion
Multi trendlines
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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.