Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Grand Total to Stacked Column Graph

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.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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