Forum Discussion

aishak12's avatar
aishak12
Helper IV
4 years ago
Solved

Combining two visuals

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...
Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • gauthamboppana's avatar
    gauthamboppana
    4 years ago

    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 !





gauthamboppana's avatar
gauthamboppana
Solution Specialist
4 years ago

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 !