Columns within Stacked Column Chart appearing too slim

[F_Reh]

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

[Anonymous]

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

[amitchandak]

@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

[F_Reh]

Thanks @amitchandak .