Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
F_Reh
Helper II
Helper II

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

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

Thanks @amitchandak .

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.