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.

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.

Clinical_Epi's avatar
Clinical_Epi
Advocate III
4 years ago

Hi MFelix,

 

Yes thats a good option - however a useful feature is to be able to drill down/up. Lets hope that Microsoft put more functions into their charts, as I find so many formatting issues could be resolved by programming in the BI tool itself, as are present in other BI tools.

We run huge dashbaords with Health data that needs to have many filters, but find developers move away from customary chart defaults (2x3 x/y standard format to a 10x2 x/y format!). I've also had to overlay charts to get the features built in that our users want.... not good 🙂

 

Thanks for updating this thread btw . 

 

The solution (for what its worth) that I've started using in most of my charts, as users need Year to month to day drill up/down in the charts, that also have lines and bars that users can add/remove using a switch/filter, is to use the full date hierarchy and turn off concatination. I explain to people that they just cant have the date as mmm/yyyy format AND be able to drill up/down functionality. Simple solution to a user end 'want' rather than need scenario. Our dashboards aren't what some would refer to as 'dumb charts' as I build in functions that dont rely on hidden pages and bookmarks etc... really fast once you nail the programming language for the data being used. 

 

Take care, Andrew - Clin Epi

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Clinical_Epi ,

     

    Thank you for your words, I also use all the options you refer on my reports, the drill on date hierarchies, some switch measures or calculation groups, sometimes with some DAX measures we can really get a work around for some of the misses on the charts and visualizations, and without making use of visualizations on top of visualizations or bookmarks.

     

    A good option currently is the charticulator visual that allows to build custom visuals without programming.

     

    Believe that with so many other tools Power BI has some strenghts and some weakeness, and in my experience when we go to advance analytics whatever the tools is programmers always have to "invent" new ways to respond to users request.

     

    Take care