Forum Discussion
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...
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.