Forum Discussion

asdf1608's avatar
asdf1608
Icon for Helper V rankHelper V
3 years ago

SVG Stacked bar in Matrix Visualization

I need to combine a matrix visualization with the measure values as Stacked bar in Power Bi. I tried to use two different charts but the format is not same. So trying to use SCG Stacked bar chart fo...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

I can work on it if you provide usable sample data.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    thank you for the sample data.  I assume you are stacking something by customer,segment, and date.  But what are you stacking? Quantity and Profit ratio have different units of measure?

    • asdf1608's avatar
      asdf1608
      Icon for Helper V rankHelper V
      3 years ago

      Then you can use "Sales and "Profit". It is just we need to stack bar in matrix visualization

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        There's a small problem 🙂  Some sample customers have negative profit ...  

         

         

        That means there has to be additional logic (across ALLSELECTED) to find the largest positive and the largest negative value in order to define the Y axis range.