Forum Discussion

F_Reh's avatar
F_Reh
Post Patron
2 years ago

Columns within Stacked Column Chart appearing too slim

Hello,

 

I have a Stacked Column Chart which shows as follows (when no Slicer selection is made):

 

 

I can enable the Data label(s) to display the total for each Month Bar, and the individual bar values can still be read by hovering and using Tool tip.

 

When I click on the Slicer to pick a selection, it becomes like this (for example):

 

 

As you can see it becomes very difficult to hover over and use Tool tip, since the individual column bars are soo slim now. Is it possible to dynamically adjust the scale of the Y-Axis when different selections are being made so that the Y-Axis and the height of the individual bars scale up or scale down to look reasonable visually ?

 

Kind Regards

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    F_Reh , Hope those three dots are not for some line used.

     

    You can use Measure in min and Max of Axis

     

    Min Axis = Minx(Values(Date[Month Year]), [Your measure]) *.9

     

    Max Axis = Maxx(Values(Date[Month Year]), [Your measure]) *.1.1 

     

    Use it Min/max of axis using fx

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, F_Reh 


    According to your description, you can change the width of the X-axis by changing the value of the Layout of the X-axis and customize the Range of the Y-axis just like this.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum