Forum Discussion

FatBlackCat30's avatar
FatBlackCat30
Microsoft Employee
6 years ago
Solved

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 l...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    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.

Frith's avatar
Frith
New Member
5 years ago

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

MFelix's avatar
MFelix
Super User
5 years ago

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:

 

 

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.