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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

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.

March Power BI Update Carousel

Power BI Community Update - March 2026

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