Forum Discussion

t-atgeor's avatar
t-atgeor
Microsoft Employee
9 years ago

Stacked Column chart - Totals

Hi, am struggling on creating a view using the Stacked Column visual, which represents two fields - IT cost and Total costs. I would like to have the IT costs as part of the Total Costs, however, the graph shows me a sum of both, which is not correct. How can I change this?

 

I thought by creating another column, called Other costs ( Total costs  - IT costs) and simply have a sum of both then, however, would be brilliant if on top, I could see a data label showing me the sum. If this is the solution, how do I get this label?

 

Thanks , Atanas

Need Help

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Create a card visualization and put Total Cost in it and then place it above your column.

     

    Unfortunately, the stacked column visualization does not allow you to have a reference line tied to a column or measure, it only currently supports a Constant line.

    • t-atgeor's avatar
      t-atgeor
      Microsoft Employee
      9 years ago

      Hi Greg_Deckler,

       

      thanks for responding. I have seen some people including a Line Value as Totals, however, it seems to be possible to only show the Total on the Line and not have the split in labels in the columns. Do you happen to know how they do it?

       

      /just like you showed in your example however without the labels in the columns and the line crossing the edge on the top and showing the Total/

       

      Thank you.

       

      Atanas

       

       

      • v-caliao-msft's avatar
        v-caliao-msft
        Microsoft Employee
        9 years ago

        Hi t-atgeor，

         

        Could you provide a screenshot about it? I have tested it on my local environment, the chart looks like below.

         

        Regards,

        Charlie Liao

  • wasim's avatar
    wasim
    Frequent Visitor
    8 years ago

    Frustrated that PBI does not have a simple Total to a stacked column/bar graph I am now using matrix tables on my graphs. I have multi periods and therefore the card method is not ideal. 

     

    Steps: Create a Matrix Table >> Change Column Header Font Color & Background to White >> Turn off the Auto-Size for Column Headers >> Outline to None >> Do the same for Row Headers>> Change Grid Outline color to white >> Send the Matrix Table to back.

     

    Hope this helps. It is not perfect but at least takes care of multi-period bar graphs provided the number of periods is constant.