Reply
F_Reh
Helper III
Helper III
Partially syndicated - Outbound

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):

 

Original Graph.jpg

 

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):

 

Original Graph 2 .jpg

 

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

3 REPLIES 3
v-yaningy-msft
Community Support
Community Support

Syndicated - Outbound

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.

 

vyaningymsft_0-1708507807060.png

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
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thanks @amitchandak .

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)