Forum Discussion

Philmo123's avatar
Philmo123
Regular Visitor
3 years ago
Solved

Adding Visuals Together

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

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

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

     

    Switch( True() ,

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

    [Column]

    )

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

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

     

    Switch( True() ,

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

    [Column]

    )

    • Philmo123's avatar
      Philmo123
      Regular Visitor
      3 years ago

      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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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.

  • Philmo123's avatar
    Philmo123
    Regular Visitor
    3 years ago

    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