Combining two visuals

Question

All,&nbsp;&nbsp;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.&nbsp;The SUM value in chart 1 in one color and the SUM value in chart 2 in another color.&nbsp;&nbsp;&nbsp;1)&nbsp;Label 1,2,3,4 Selected:&nbsp;2)&nbsp;Label 5 Selected:&nbsp;&nbsp;This is the format of my data:&nbsp;Column 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column 2)Label 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Label 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Label 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30Label 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25Label 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40

gauthamboppana · Accepted Answer

aishak12&nbsp; - Create two new measures. Ones for summing up&nbsp;labels 1,2,3,4&nbsp; and another for label 5.&nbsp; You can use these two measures in the column charts.Sum1 =&nbsp; calculate( sum([column2]),&nbsp; [column1] in {"Label 1","Label 2","Label 3","Label 4"}Sum2 =&nbsp; calculate( sum([column2]),&nbsp; [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.&nbsp; It is a token of appreciation!Thank you very much !

Forum Discussion

Combining two visuals

1 Reply

Related content

Tables combine

How to combine to matrix visuals

Data Combining Problem

Combine Column

Dynamic RLS combination