Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PowerBI Stacked Column Chart with Legend Error

Hi Guys, 

 

I am new to PowerBI. I am trying to create the Running Total Stacked Column Chart (on the right) with the categories in the column bars and I get the char on the left. You could see that the running total for both charts are different. 

 

Could someone please to me the error and how do I resolve this?

 

Thank you.

 

N.

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , I Hope there is no missing value for the legend you used in the dimension of fact side


    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      the data is confidential. i cannot share the sample data. Any other suggestions, solutions and/or reference links that I can refer to?

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi,

    If you want to have the sum of the B and C on X-axis, you need to create a column that sums the particular columns and use it in your visual(s),

    or if you want to see both as a separate column, you need to use the Clustered Column Chart.

    Appreciate your Kudos