Forum Discussion
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.
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
Hi Anonymous,
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,
5 Replies
v-jiascu-msftMicrosoft Employee
Hi Anonymous,
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
Post Prodigy
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.
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
hi, unnijoy are you able to resolve the issue? I stuck in the same place.
Hii,
how do i sorth the month name which are just "text ", as created
