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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Line and staccked column chart total value showing wrong

I have Line and staccked column chart am trying to display total values on top of bar but the value is showing wrong.when I tried to display the value in card or table visual showing correct but in Line and staccked column chart it is showing wrong 

 

example when when I use measue in card or table total value as 2.30% but am trying to display same in line and stacked column chart total value is 26.19%

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Because it seems that power bi have the limitation for the stacked column chart, so if you have too many legends, it will only show part of them.

 

You could  change a chart type to show your data,

or group by your data then show it in your chart.

 

Silimar case refer:

vluwangmsft_0-1646272237965.png

https://community.powerbi.com/t5/Desktop/Stacked-Column-Chart-showing-wrong-value-total-on-Y-axis/m-p/1808175 

 

Did I answer your question? Mark my post as a solution!And if question still alive ,could you pls share your pbix file ,and remember to remove confidential data.


Best Regards

Lucien

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

 

Best Regards
Lucien

v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Because it seems that power bi have the limitation for the stacked column chart, so if you have too many legends, it will only show part of them.

 

You could  change a chart type to show your data,

or group by your data then show it in your chart.

 

Silimar case refer:

vluwangmsft_0-1646272237965.png

https://community.powerbi.com/t5/Desktop/Stacked-Column-Chart-showing-wrong-value-total-on-Y-axis/m-p/1808175 

 

Did I answer your question? Mark my post as a solution!And if question still alive ,could you pls share your pbix file ,and remember to remove confidential data.


Best Regards

Lucien

amitchandak
Super User
Super User

@Anonymous , can you share how the measure is created?

 

refer if this can help

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 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.