cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RazielReaver Frequent Visitor
Frequent Visitor

Bug in stacked chart total

There is a bug in stacked chart.. for some reason the subtotal is not getting the real value, even if the values are showing, i made the stacked chart into a matrix to see what it was doing an it is just going nuts Smiley Frustrated

 

from the label "Semana de 2017-11-06 al 2017-11-12" the sum it is incorrect.

 

what

6 REPLIES 6
Community Support Team
Community Support Team

Re: Bug in stacked chart total

Hi @RazielReaver,

 

The snapshot is too small. I can't see what's inside. 

1. Could you please share a more clear snapshot?

2. Which visual exactly? The Stacked column chart or the Stacked bar chart?

3. The Total evaluates the formula under the context, which isn't the sum of values we can see from the Matrix. Please check it out.

4. Could you please share a sample pbix file?

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RazielReaver Frequent Visitor
Frequent Visitor

Re: Bug in stacked chart total

As you can see. nether the total in the columns, nether the total in the rows are the value with it is supposed to be..  I can share a pbix file..  where can i upload it??

 

I used a Matrix to show the real values that it is getting as a grand total, the problem is that, I cant get a real total value with the stacked chart, it give me the 0.90 instead of the 1.11 that it should give.

Community Support Team
Community Support Team

Re: Bug in stacked chart total

Hi @RazielReaver,

 

You can upload your file to a cloud driver like GoogleDrive, Dropbox, OneDrive. Then share the link here if you can make it public or send me a private message with the link.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RazielReaver Frequent Visitor
Frequent Visitor

Re: Bug in stacked chart total

OK, I uploaded the file to onedrive and send you the link.. 

 

I hope you can help me find an answer.

 

Best Regards,

Ricardo

Calcul8or Frequent Visitor
Frequent Visitor

Re: Bug in stacked chart total

Hi Ricardo,

Did you ever get a solution to this? I'm having the same problem.

RazielReaver Frequent Visitor
Frequent Visitor

Re: Bug in stacked chart total

No, i solved it myself, it was a long time ago..

 

I fixed changing the way I uploaded or tried to find the info, creating columns and not searching them from other tables.

 

this is my example:

 

Rendimiento Piedra = SUM('Guias de Ingreso'[PiedraM3]) / sumx(FILTER('Guias de Despacho';'Guias de Despacho'[MaterialId]="4");'Guias de Despacho'[Metros Cubicos])