IBCS-styled Column Chart in Power BI Matrix Visual | It's NOT a Custom Visual !!!

How can you create an IBCS-styled column chart in Power BI using just the built-in Matrix visual and a single DAX measure?

What does the DAX measure used to generate the chart do?

How can you create a three-line title (IBCS-recommended title layout) in Power BI visual?

Why are the columns in this IBCS-styled chart either solid black, hatched, or outlined?

What do the gray triangles represent?

What do the green/red rectangles signify?

===
Power BI Implementation: Andrzej Leszkiewicz, IBCS® Certified Analyst

00:00 Intro. What do we see on the chart?
01:28 Chart review
04:52 Chart review v.2 (sorry, video editing error, 2 versions of the same chapter)
09:20 How the chart was created? (Matrix Visual, 3 lines title)
15:40 DAX measure that creates SVG code (code review)
31:29 Final comments

[DeronHuskey]

WOW! Just beautiful. The decomposition of the SVG was incredibly informative.

Thanks for doing this.

[power-of-bi]

I'm sorry for the duplicated chapter. Video recording/editing with COVID or whatever I'm still recovering from is harsh. I probably had to wait a few days or a week more, but I really wanted to publish this video sooner.

[JacintaVayo]

Andrzej this content is invaluable! 🤩
thanks for sharing your knowledge with the community, your dedication and passion for data analysis and visaulization is evident. It's amazing the result you reached, well done for this incredible development!!!
I wish you a lot of success!!!

[priscilalopes]

Congratulations. Your development is incredible.

[nathanielbaluyot]

Is the column chart not available on your GitHub anymore?

[SergiyVakshul]

Hi, Andrzej. Great job. One thing still is bothering me. The visualization you presented looks perfect until the displayed numbers are low or equal 999. What if the sales vary from 500k per month to 10000K? In that case the width of the labels might be wider than the width of the columns, which won’t look well. You might have thought of that already. What were your thoughts on that account? Will you make your table wider and put up with a horizontal scroll bar? Will you do the opposite?

[apbreports]

Great work Andrzej!
It would be great if the chart could be resized automatically based on the matrix size. Then we could fit 8 of these amazing IBCS charts on the same page.
Also in the measure if you could add a VAR to flip the chart to a horizontal bar instead - or perhaps we need to code another measure for that.
I would have considered moving all total texts above the columns to make it less cluttered. For example for July it gets tricky to see the top of the bar etc

[MrAszpic]

I would like your point of view on the pros and cons of creating svgs this way vs. deneb. From the start, peope would have to learn any of the 2 languages (yeah I am referring to creating the shapes here as a language, nevermind the technicality). Both methods allow for custom tooltips. This one can be done with native visuals, a plus for companies that restrict custom visuals. Probably a con if this method may be that it is a bit complicated DAX-wise to add a related chart, like an absolute variance column chart on top; you would need another row of the matrix for that... unless you can make a X axis that goes all the way without being chopped by the inner borders of the matrix visual?

[power-of-bi]

Question: why there is no color legend (AC - solid black, FC - hatched, AC-PL > 0 - green etc.) in the 3rd title row.
Answer: when IBCS standard is implemented in an organization, usage of solid black for actuals, hatched for forecasts, outlined for plans become a standard for all charts. Also green on all charts means good and red means bad. Note that reduced sales = bad, but reduced costs = good and therefore green. There is no need to use a legend in a standard business chart anymore. You can understand any chart almost immediately. This is one of the advantages of IBCS.