Want to Upgrade Your Power BI Matrix into an Advanced IBCS Style Data Visualization? Here's How!

In this video, I explain how to create an advanced visualization based on the International Business Communication Standards (IBCS) using just the native matrix visual in Power BI. There's no need for the Deneb custom visual or Vega and Vega-Lite coding. I'll demonstrate a few simple DAX measures that can transform a basic matrix into an advanced visualization, embedding three different charts within the matrix.

00:00 Into
00:11 Custom Deneb Visual vs Core Matrix Visual
01:00 This is not Deneb, just a Matrix
02:55 DAX Measures that generate SVG code for the charts
03:35 First DAX Measure: AC, PY chart
15:57 Second DAX Measure: ΔPY chart
22:58 Third DAX Measure: ΔPY% chart
25:07 Final Comments

[JA-ivnp]

Love this type of content with native (built in) Power BI visuals. ♥

[distrilanalytics]

Great. I already have Upgraded Matrix visual as Pivot Table available in Excel. Now let's further upgrade like this. Teach & Love learning

[kot]

A big thank you my friend, with your excellent tutorials you saved me so much time! Also a great inspiration on how to design and implement SVG code. Thanks!

[powerbininja]

thank you sir! Much respect to your name 👏👏

[patrickbrom]

Good stuff, going to use this in my portfolio dashboard! Thanks for sharing.

[BbabbittGolf]

This is mind blowing, thanks for the content!

[AccessAnalytic]

Great, thanks for sharing and explaining and the link to download the file.

[MrAszpic]

Thank you for sharing this kind of work!

Would something similar be doable with Deneb? If so, what would be the pros/cons of each technique?

[patricioolivares]

Congrats for such an interesting video, Andrzej! Very helpful information. I have one question, maybe you can kindly provide some insights on it: is it possible to create a Gantt chart that shows two bars in one cell (one bar for baseline dates, and the second for current dates) with the length of the bars being the elapsed time between dates using SVG and measures in the matrix visual? If so, do you think this can be part of an upcoming video? Thanks!

[paser]

Brilliant work, giving both data position and direction! Thank you for sharing this.

[lkicdrl]

This is next-level pioneering work. The only issue I have when attempting to implement is having the scaling of the base numbers identical to the scaling of the absolute variance numbers, which is a must for IBCS. Any ideas on how to accomplish this identical scaling?

[businessinsights_AlexRobe]

Great video, thanks!
I gave it a shot and found out, that if you have other locales running than en-EN you have to get rid of all the comma values in the FORMAT commands.
e.g. FORMAT ( _WidthValue, "0.0%" ) must become FORMAT ( _WidthValue, "0%" )
Thanks again!

[zacs]

Excellent work Sir! Thank you for sharing!

[beaglesandbunnies]

Hi, this is amazing. Is it possible to make this into an income statement with hierarchy. The problem I am having is I want it to be only a few lines like gross sales, total cost of sales, and operating income. Then from there you can expand to further levels like operating expenses, other income, etc. the issue is it is ragged data and some income statement lines go down 3-4 levels while others only go down one level. The you have to expand it 4 times and there are blank rows. Any help would be amazing!

[tonyhartigan]

Absolutely brilliant. Really enjoyed your walk-through. Very clear. (Subscribed)

[JulianoGrapeggia]

Can I achieve this look with DENEB? In a way where I can put the measurements in the DENEB configuration itself and it generates the look for me?

[OleksandrChekoi]

Thanks, great video, but no access to file

[bouhdaryyouness]

Who achieved this customized table on powerbi, i need help asap

[apbreports]

Just curious if we can set the width of each chart separately. I want to set delta charts to half the width.