cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FatBlackCat30
Microsoft
Microsoft

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!!

1 ACCEPTED SOLUTION
MFelix
Super User III
Super User III

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

6 REPLIES 6
MFelix
Super User III
Super User III

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

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 🙂


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hey @MFelix , there is already an idea that needs more votes: 

Microsoft Idea  · Set default x axis scrolling position (powerbi.com)

 

Anyhow I fully agree with @Clinical_Epi. It is really some kind of shame that this must be pushed via an idea and was not implemented from the very beginning. I use a text format (monthname-year) that is also common but not provided as a date format and so it is even not possible to reorder the x-axis because it is not an option for text formats...

Thank you Frith for the link I will check it out and vote. Any BI tool should have this built in, but most people dont seem to get how important this capability is in certain settings... 

MFelix
Super User III
Super User III

Hi @Frith ,

 

Thank you for the message I will vote in.

 

Concerning the second part of your message is possible to have a Montname-year by custom formatting:

MFelix_0-1611575162838.png

 

 

Or adding a new column with:

 

FORMAT( Table[Date], "mmm-yyyy")

 

You also need to add a sort column using the following code:

FORMAT(Table[Date], "yyyymm")

Now the values will be correct on your chart.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors