Grand Total to Stacked Column Graph

[Anonymous]

Hi all,

Looking for some help, suggestions or thoughts around adding a company grand total column. 

Currently we are reporting on our open roles across the business and breaking this into BAU or Project Based. Below is what I have pulled together (example is within Excel but also have it in Power BI). 

X Axis breaks it out into each team across the business, however I have been asked to also include a company total split - after advice or suggestions on how I can display this.

Thanks in advance.

[Anonymous · Accepted solution]

HI @Anonymous,

>>X Axis breaks it out into each team across the business, however I have been asked to also include a company total split - after advice or suggestions on how I can display this.

AFAIK, stacked column chart not contains analysis total split function.

In my opinion, you can use original table to create new table with summary records row and use this table as source of stacked column chart.

Sample:

New Table =
UNION (
    Table,
    UNION (
        ROW (
            "team", "Total",
            "Role Type", "BAU",
            "Sales", SUMX ( FILTER ( ALL ( Table ), [Role Type] = "BAU" ), [sales] )
        ),
        ROW (
            "team", "Total",
            "Role Type", "Project",
            "Sales", SUMX ( FILTER ( ALL ( Table ), [Role Type] = "Project" ), [sales] )
        )
    )
)

In addition, you can also submit an idea for this requirement.

Regards,

Xiaoxin Sheng