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...
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.

 

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

    lbendlin Can you please send the PBIX file so that I can refer

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

    I haven't done any SVG work yet, waiting for your guidance. The example was based on Small Multiples.

     

     

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

    lbendlin Thank you for for help until now. I have updated the PBIX file. Here there are no negative values and you can refer page1 for the fields to be used for the stacked bar chart in SVG.

    Can you please try in this and get the stacked bar chart

    sample.pbix

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

    lbendlin Can you please look into it ans get me the stacked SVG Barchart. I am still struggling to get it correct. 
    Help from you will be appreciated.
    Thanks

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

    lbendlin any luck? I need this Stacked SVG Bar. Help in this is really needed

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

    lbendlin  is this possible in svg. I tried it but didn't get what needed.

    have you tried it?