topic Re: SVG Stacked bar in Matrix Visualization in DAX Commands and Tips

SVG Stacked bar in Matrix Visualization

asdf1608 — Fri, 17 Mar 2023 06:59:44 GMT

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

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Sun, 19 Mar 2023 20:45:14 GMT

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.

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Mon, 20 Mar 2023 07:02:09 GMT

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

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Mon, 20 Mar 2023 11:23:50 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Tue, 21 Mar 2023 12:50:12 GMT

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?

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Tue, 21 Mar 2023 12:56:41 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Tue, 21 Mar 2023 13:43:39 GMT

lbendlin Yes. This is the sample data
Book1.xlsx

PBI File: sample.pbix

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Tue, 21 Mar 2023 15:20:51 GMT

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?

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Tue, 21 Mar 2023 15:55:27 GMT

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

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Tue, 21 Mar 2023 17:48:08 GMT

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.

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Wed, 22 Mar 2023 14:31:02 GMT

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

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Wed, 22 Mar 2023 16:04:30 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Thu, 23 Mar 2023 08:15:09 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Fri, 24 Mar 2023 07:00:57 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Fri, 24 Mar 2023 16:08:02 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Mon, 27 Mar 2023 07:29:22 GMT

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

have you tried it?

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Thu, 30 Mar 2023 13:27:37 GMT

lbendlin Any update on this?

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Thu, 30 Mar 2023 14:12:39 GMT

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

Re: SVG Stacked bar in Matrix Visualization

asdf1608 — Thu, 30 Mar 2023 14:12:02 GMT

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

Re: SVG Stacked bar in Matrix Visualization

lbendlin — Thu, 30 Mar 2023 22:25:09 GMT

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