Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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

0

Y axis should correspond to the total of the stacked columns in the chart

Submitted by Anonymous on ‎05-30-2023 04:45 AM

"Why is 13K higher than 15K?"

In this graph the column bar shouldn't be higher than 15K on the Y axis because the sum of stacked columns adds up to only 13.2K. The Y axis is higher because it adds up all the numbers in the stacked columns, ignoring the minus sign.

LenFi_0-1685446557863.png

 

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎05-30-2023 07:12 PM

Hi @Anonymous 

You can see the difference in the two screenshots below. When you add a grouping in the legend, the column chart will reflect the values corresponding to the grouping, this time the sum is the sum of the values, but the graph is to reflect the positive and negative values.
But when you remove the grouping, it is reflected in the graph as a sum, so the graph can be consistent with the scale on the left.

vyetao1msft_0-1685498652964.pngvyetao1msft_1-1685498789572.png

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses