cancel
Showing results for
Did you mean:
Regular Visitor

## Grand Total in Bar Chart

Dears,

I have below chart prepared calculting total spend busienes unit wise comparing two years and I need to see total of 2018 vs 2019 for all business unit at the end of chart.

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Suppose that you have a dataset like that

 a 1 sum 2018 b 2 sum 2018 c 3 sum 2018 a 2 sum 2019 b 3 sum 2019 c 4 sum 2019

the "sum" values in the table were added by me with creating column in power bi

Summarized the dataset like that

 sum 6 all 2018 sum 9 all 2019

"all" values in the table were added by me with creating column in power bi

and union this two table then i got this view. I thought it was fine for you

Microsoft

Another approach is as follows. You can download the demo from the attachment.

1. Create a new table.

```Units =
UNION ( VALUES ( Table1[Unit] ), { "YearlyTotal" } )
```

2. Create a measure.

```Measure =
VAR amount =
SUM ( Table1[Amount] )
RETURN
IF (
ISBLANK ( amount ),
CALCULATE ( SUM ( Table1[Amount] ), ALLEXCEPT ( Table1, Table1[Year] ) ),
amount
)
```

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Anonymous
Not applicable

hi, @unnijoy  are you able to resolve the issue? I stuck in the same place.

Microsoft

Another approach is as follows. You can download the demo from the attachment.

1. Create a new table.

```Units =
UNION ( VALUES ( Table1[Unit] ), { "YearlyTotal" } )
```

2. Create a measure.

```Measure =
VAR amount =
SUM ( Table1[Amount] )
RETURN
IF (
ISBLANK ( amount ),
CALCULATE ( SUM ( Table1[Amount] ), ALLEXCEPT ( Table1, Table1[Year] ) ),
amount
)
```

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Partisan

I have a similar case. But if in Unit the total amount is 0 then it is shwoing the overll total for that purticular year.( For example lets take GV 2019. If the total Amount for GV 2019 is 0 then it should show as 0.

As per the above formula it will show 29 ( 2019 Yearly total) for GV 2019. I need it to be 0.

Anonymous
Not applicable

Suppose that you have a dataset like that

 a 1 sum 2018 b 2 sum 2018 c 3 sum 2018 a 2 sum 2019 b 3 sum 2019 c 4 sum 2019

the "sum" values in the table were added by me with creating column in power bi

Summarized the dataset like that

 sum 6 all 2018 sum 9 all 2019

"all" values in the table were added by me with creating column in power bi

and union this two table then i got this view. I thought it was fine for you

Announcements

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors