Forum Discussion
Line chart scroll aligned right
Hello all,
I have a line and stacked column chart with 3 years of data in it. The problem is the latest date (2017) is showing all the way to the left and the scroll automatically starts at the left. is there a way to have the scroll to start at the right with the most recent data?
thank you!!
Hi FatBlackCat30 ,
You cannot change the default scroll setup.
Has a workaround you can decrease the size of the bars and the space between them so they are closer and have more information visible, increase the size of the visual or change the sorting order of the axis.
10 Replies
Hi FatBlackCat30 ,
You cannot change the default scroll setup.
Has a workaround you can decrease the size of the bars and the space between them so they are closer and have more information visible, increase the size of the visual or change the sorting order of the axis.
Hang on a second... so the one thing people rely on in charts for decades on computers - ie: having the line bar selector at the bottom of the page start from the right hand side of a chart that exceeds the dimensions of itself is not an option?
Lets just throw all convention out the window why dont we?
Make the data (whether it be months or what ever on the Y axis) smaller deafeats the purpose of a drill down which expans the graph beyond its boundaries making you HAVE to scroll to the most recent data every time you refresh the page... No bookmarks or tricks will work this one out - it has to be added as a function by the software developers Microsoft.
Very annoying and a big red mark against Power Bi (which I love btw)...
Hi Clinical_Epi ,
I understand what you are saying and may agree with you that these type of adjustments to the visualizations is needed.
However and please don't see this as being disrespectufull, it's not throwing all the conventions out of the window, in my case while working with a lot of visualizations from Excel, Tableau and Power BI (among others) , some as creator and some as read only I have learn in the last years that having more information in a single visualization is not necessarily good, if you cannot take the main message from the values you are seeing imediatly maybe something needs to be change.
Again this is my personal perspective and in no means I'm deprecating your opinion.
The work around can be to create inverse the timeline order (also not logical), don't know the correct because sometimes things come from a full perpspective of your reports and it can totally make sense to have a line chart.
You can also check if there is an idea on the forum part for ideas.
Just getting some open discussion about what are the alternatives, but if you make the idea on the forum please tell me and I will be the first one to mark as needed 🙂
The easiest work-around I've found is just to reverse the order on the x-axis:
- Go to 'More Options' on each visual's header- Scroll over Sort Axis
- Click the axis you want to reverse the order of
Of course, users would rather have the dates go from oldest (on left) to newest (on right). Thanks Frith for the link to vote on the issue!
