Combining two visuals

[aishak12]

All, 

I have two stacked column charts. I want to combine the visuals to plot both values into one chart. It should show two different colors in the new chart.

The SUM value in chart 1 in one color and the SUM value in chart 2 in another color. 

1) 

Label 1,2,3,4 Selected:

2) 

Label 5 Selected:

This is the format of my data:

Column 1)                 Column 2)

Label 1                       10

Label 2                       20

Label 3                       30

Label 4                       25

Label 5                       40

[gauthamboppana · Accepted solution]

@aishak12  - Create two new measures. Ones for summing up labels 1,2,3,4  and another for label 5.  You can use these two measures in the column charts.

Sum1 =  calculate( sum([column2]),  [column1] in {"Label 1","Label 2","Label 3","Label 4"}
Sum2 =  calculate( sum([column2]),  [column1] = "Label 5")

Let me know if you have any questions.

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !