Forum Discussion
Anonymous
2 years agoNot applicable
Line chart for different countries for different period
Hi everyone, I need to show 5 coutnries in a line chart with actual, and forecast. Actual being the solid lines, and forecast being the dotted lines. When I add the countries to the legend, i can...
HotChilli
Community Champion
2 years agoGenerally, the way to get around the limitations of the line chart is to write separate measures for the values. So you might start with 2 measures: one summing the Actuals and one summing Forecast. Put them both in the Y-axis section. You can change the line type in the 'format' section (dotted or solid, for example).
It would be great to put Country in the Legend but it won't let you. You can use Small multiples or add a Country slicer if required.
---
There's an alternative solution if you re-organise the data :
https://exceleratorbi.com.au/plotting-2-columns-on-the-legend-of-a-chart/
Have a look at these and see how you get on
- Anonymous2 years agoNot applicable
Thanks for the reply,
Yes unfortuantely it didnt solve the problem. I hope they fix it soon.