Forum Discussion
Helper IIAdd "Total" on same level as current calculated dataset for line chart?
Impactful IndividualHi nbrandborg,
Please can you check the 'Edit Interactions' from the Modelling pane in the ribbon, that they have not been turned off for the slicer and visual to interact.
Alternatively, you can check the measure as well in case you have used ALL() or some iteration of the ALL() function to ignore the slicers somehow.
I checked it with my reports and the slicers are working alright.
Regarding the X-axis, please post pictures showing the difference that you are talking about, as I am still not able to understand the problem there.
If my response helped you solve the problem, please kudo or or mark it as a solution so that others can reach the solution faster.
Thank you,
Vishesh Jain.
Helper IIHi visheshjain
Here's the picture showing the difference in the width of the x-axis which are dynamic in terms of how much space the legend takes on the left. Right now the two line charts (one with all the countries and the Total Monthly Weighted Average) are overlayed on top of each other.
Here's first a picture with all the countries selected:
And here's the chart with only "USA" selected.
As you can see the "Line chart area" becomes bigger when a country with few characters are selected and the overlay doesn't match up anymore on the left side of the chart.
Ideally we could lock the Line chart or Legend area, as the overlay solution would be a good workaround to solve the issue.
AleResolver II
One thing you could try is to change the legend's position. Try having it above or below the chart, so the X-Axis scale won't change.
Another solution would be to have the legends in a different visual. Create a chart with the same legends but make it transparent (or hide it behind the original one). So, when you select only 1 country, the selection it will affect only the "background" chart axis, not the original one.
- visheshjain
Hi 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
- nbrandborg
Sorry, 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