Forum Discussion
Helper IIAdd "Total" on same level as current calculated dataset for line chart?
Impactful IndividualHi nbrandborg,
As pointed out correctly by Ale, you can change the position of the legend to be above or below the line chart from here.
One more thing that I noticed and that you can do to manage the X-axis, is that you are using the MMMM for month in your dates, which gives the full name of the month and will vary according the name of the month.
So instead of MMMM you can use MMM to lock the month name to 3 characters and this way you can have the X-axis fixed.
I hope this helps solve all your issues and if it did, please do mark it as the best answer and/or kudo it, so that others can reach the solution faster.
Thank you,
Vishesh Jain
Helper IISorry, but the X-axis is not locked by the character length of the months. I tried to change it to MMM as suggested, but unfortunately it's caused by the legend size. When USA is picked as single-selection the entire chart area still moves to the right.
As mentioned before, moving the legend to the top or bottom is not an option as it's too long, and we would like all countries to be displayed all in once.
- visheshjain
Hello nbrandborg,
The character length and position of the lengend is determintal in moving of the X-axis and is the only solution available.
However, if you are going to use the small multiples, then the country name will be visible at the top/bottom of the chart, eliminating the need to have legends.
As of now this is the only solution that I can think of, unless someone has any other solution or if the product team comes up with a new feature.
If you find any other solution, please do update the thread so that others can reach the solution faster.
Thank you,
Vishesh Jain