Reply
Cobalt58_9
Frequent Visitor
Partially syndicated - Outbound

Change Y Axis Value

Hi gang, maybe it's because it's late, or maybe it's because I've gotten too many notes back, but does anyone know how to change the y-axis value on a Stacked Column Chart? I want it to look like this: 

Cobalt58_9_0-1714081255629.png

Instead it's giving me the thousands count on the left rather than the two numbers equalling 100%.

Thanks, and feel free to insult me for this.

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

Syndicated - Outbound

You can use the 100% stacked column chart and slap on some data labels for the actual amount

vicky__0-1714085271308.png

 

View solution in original post

3 REPLIES 3
v-yilong-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Cobalt58_9 ,

Your solution is great, @vicky_ . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I create a visual as you mentioned.

vyilongmsft_0-1714096172180.png

You can also open the Data labels and Value. It will show you what you want.

vyilongmsft_1-1714096328785.png

vyilongmsft_2-1714096345808.png

vyilongmsft_3-1714096382914.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vicky_
Super User
Super User

Syndicated - Outbound

You can use the 100% stacked column chart and slap on some data labels for the actual amount

vicky__0-1714085271308.png

 

Syndicated - Outbound

Good grief, that did the trick. Thank you so much.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

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