cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 :S

 

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

 

what

6 REPLIES 6
Microsoft v-jiascu-msft
Microsoft

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.

Microsoft v-jiascu-msft
Microsoft

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])

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors