SVG Stacked bar in Matrix Visualization

[asdf1608]

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 for three columns

1)a = MIN(Column1)

2)b = MIN(Column2)

3)c = MIN(Column3)

How do I create a SVG to display the bars like this

Help in this is needed

[asdf1608]

@lbendlin Any update on this?

[lbendlin]

no, still learning how to use VCONCAT properly in Deneb, and how to translate that the SVG code.

[asdf1608]

@lbendlin Thank you for your effort. I tried to get in other ways the stacked bar chart in matrix visualization. Still nothings. So the only possibility is SVG in which I need help

[lbendlin]

Looking at the data again I still see negative profit numbers. I think a clustered column chart is more appropriate for that to display.

[asdf1608]

@lbendlin I can't use that because we need the data to be in table format and the measure values to be in bar chart. 

[lbendlin]

You hand craft the SVG code for that type of visual (including the rendering of the Y axis and the calculation of the Y offset for the bars) and then you present that SVG to the image in the matrix cell.  

Start with sample data and create the SVG for the desired output. Then make the parameters dynamic.

[asdf1608]

@lbendlin Yes I tried to do that but I am not getting in stacked bar and I couldn't find any samples for stacked bar. Can you refer any stacked bar SVG .

Please help this is an emergency

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[asdf1608]

@lbendlin I need to display a matrix with three values in stacked bar chart. 

For Example:

Here in table format the measure values "Profit", "Calculation1"and "Quantity" are in stacked bar.
I need the same thing in power BI. This is possible thorough SVG. But I am not getting any sample for this.
Can you give idea to get this stcaked bar?

[lbendlin]

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

[asdf1608]

@lbendlin Yes. This is the sample data
Book1.xlsx

PBI File: sample.pbix

[lbendlin]

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]

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

[lbendlin]

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]

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

[lbendlin]

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

[asdf1608]

@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]

@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]

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

[asdf1608]

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

have you tried it?