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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

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

"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

Hi @LenFi 

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

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

Hi @LenFi 

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