Adding Visuals Together

[Philmo123]

I would like to know if it is possible to sum visuals. I need to add the values of Civils, TRR, etc together to make a summary.

Currently I have been unable to find anything that will let me do this, so hopefully someone can help as my brain is scrambled!

Many thanks

Phil

[Philmo123]

Thanks for coming back to me @v-xiaotang but I don;t think so.

I have 5 different code groups. Within those 5 code groups i have TRR, Civils, UG, OH and Poles.

For each code group there is a quantity and has a summation sign against on the data.. So codes groups 1-5 have CodeQty1-5. Which matches the bar chart as seen on the first message on this forum.

I need to be able to sum these values from each Code group.

If I merge onto one visual, the filters cancel each other out. They have to act independently in order for me to get the total of all TRR within code groups 1-5, and Civils, etc. 

I.e Code Group 1 - Civils - 70291

     Code Group 2 - Civils - 42186

     Code Group 3 - Civils - 13050

     Code Group 4 - Civils - 8284

      Code Group 5 - Civils - 305

I need to add these together and sum them into a total.

How do i do that, and can I?

Thanks

Phil

[v-xiaotang]

Hi @Philmo123 

Thanks for reaching out to us.

>> I would like to know if it is possible to sum visuals. I need to add the values of Civils, TRR, etc together to make a summary.

is this you are looking for?

Solved: How to Create Multi-category Charts with legends - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Philmo123 , You need to create a new column and use that on axis

Switch( True() ,

[Column] in {"Civils", "TRR"} , "CivilsTRR",

[Column]

)

[Philmo123]

Thankyou @amitchandak  but i'm a little confused.

Where am i adding the new column to?

I have made 5 sets of groups. Each group has a code qty field affiliated with them (Code Group 1 goes with codeqty1, then 2, then 3, etc)

So in order to get the value correct of all Civils in Code Group 1,2,3,4 & 5, i need to be ab able to sum all the values independently to get the true value.

Would the solution above allow that, and if so, where am I adding the column? DO i need to change from bar chart to table to do a SUMX? I just need to sum the values for each group 1-5 to summarise it.

Thanks