Grand Total in Bar Chart

[shaikhshafiii]

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. 

[Anonymous · Accepted solution]

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

You can download pbix from there

[pbi_user000]

Hii,

how do i sorth the month name which are just "text ", as created

[Anonymous]

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

[v-jiascu-msft · Accepted solution]

Hi @shaikhshafiii,

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,

[unnijoy]

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. 

Please help.

[Anonymous · Accepted solution]

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

You can download pbix from there