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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
efeurich
Helper I
Helper I

Strange behavior of Stacked column Chart

I added some data to a report, and now the Stacked Column Chart doesn't behave the same for different years.

See the attached files. I already tried to reset the visual but with no result. What am i doing wrong?PBI001.png

 

PBI002.png

 

PBI003.png

 

 

3 REPLIES 3
amitchandak
Super User
Super User

@efeurich , You are using fill/highlight  interaction.

In this can if the % value because of drill across is more than you current % you will see second case and if it less you will see the third case

 

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi amitchandak,

I have found a way to keep the percentages readable in the diagram.

But it is not exactly what I want.

If you have any suggestions on how to do it better, please feel free to advise me 

Ok, I understand, but I am unable to resolve it. What do you mean with current percentage?

I just have one spreadsheet with all the data in it. No value is current here.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors