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

Рет қаралды 11,858

Data Visualization in Power BI and Beyond

Күн бұрын

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
PBIX file and DAX code for the measures: github.com/avatorl/PowerBI/tr...
Visualization design is based on IBCS guidelines: www.ibcs.com/ibcs-standards-1-2/
Not produced, not certified, not authorized, not endorsed by IBCS® www.ibcs.com/

Пікірлер: 52

@PowerBIPark 10 ай бұрын

10/10 this channel is taking off! 🙏🙏

@SSM_33 10 ай бұрын

I agree

@JA-iv8np 10 ай бұрын

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

@power-of-bi 10 ай бұрын

Thanks. Buil-in visuals have their limitations and require some tricks to override the limitations, but it's a pleasure to be able to get more from them (and there are many reasons to prefer them over custom visuals).

@zacs7971 10 ай бұрын

Excellent work Sir! Thank you for sharing!

@shooben 10 ай бұрын

Fantastic work! 🙌

@alirezahossini463 10 ай бұрын

New tips and tricks. Thank you

@powerbininja8270 10 ай бұрын

thank you sir! Much respect to your name 👏👏

@paser2 10 ай бұрын

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

@power-of-bi 10 ай бұрын

Glad you enjoyed it!

@distrilanalytics 10 ай бұрын

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

@tonyhartigan4668 10 ай бұрын

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

@power-of-bi 10 ай бұрын

Thank you Tony!

@rlds07 10 ай бұрын

Excellent work, congratulations!

@power-of-bi 10 ай бұрын

Thank you!

@SSM_33 10 ай бұрын

I can't wait for it

@kot23 8 ай бұрын

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!

@power-of-bi 6 ай бұрын

I'm glad the video helped you! Thanks for the comment.

@patrickbrom2702 9 ай бұрын

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

@power-of-bi 6 ай бұрын

You're welcome!

@malanam 10 ай бұрын

Amazing work!! Thank you for sharing

@power-of-bi 10 ай бұрын

Thanks for watching!

@mina_saad 10 ай бұрын

Thanks for sharing

@LeighRadmore 10 ай бұрын

This is immense, thanks very much!

@power-of-bi 10 ай бұрын

Thank you! New video is coming: kzfaq.info/get/bejne/p5NpY6aexNjUYas.html

@apbreports 10 ай бұрын

This is awesome work!

@power-of-bi 10 ай бұрын

Thanks a lot!

@bilearner 10 ай бұрын

Very great content 👍

@AccessAnalytic 10 ай бұрын

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

@power-of-bi 10 ай бұрын

Glad it was helpful!

@pavanagrawal 10 ай бұрын

This is superb!!!

@power-of-bi 10 ай бұрын

Thank you!

@businessinsights_AlexRobe 10 ай бұрын

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!

@power-of-bi 10 ай бұрын

Thanks for the comment. Yeah, the FORMAT works differently depends on regional number formatting settings.

@kondziunia 10 ай бұрын

Extra! Super tip!

@power-of-bi 10 ай бұрын

Glad it was helpful!

@bulbulahmed3098 10 ай бұрын

❤❤❤

@JulianoGrapeggia 8 ай бұрын

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?

@power-of-bi 6 ай бұрын

Yes you can. See github.com/avatorl/Deneb-Vega/tree/main/ibcs-three-tier-chart

@user-lk9ic7dr9l 7 ай бұрын

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?

@power-of-bi 6 ай бұрын

Use absolute values (not variance) to calculate scale ratio and then apply this scale to the absolute variance.

@patricioolivares5152 9 ай бұрын

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!

@power-of-bi 9 ай бұрын

Thanks. That's a great question. It's possible to draw multiple bars in a cell. The question is what are you going to have in the columns. It makes sense to have a date per column, therefore what you need is a either blank cell or a cell with 100% column width bars. Although, there will be an issue, you'll have non-removable margins around the SVG images (empty space between the columns). If ability to select a single date is no important you can have put for example weeks into the columns and wider (up to 512 pixel) SVG images to draw bars with variable length (to cover start-end date period).

@patricioolivares5152 9 ай бұрын

@@power-of-bi Thanks for the fast response, Andrzej! I really appreciate it! It seems like its possible to prepare such Gantt chart, but there are some workarounds to be considered. I am still a newbie using PBI and will investigate more according to your feedback. Greetings from Poland! ;)

@apbreports 10 ай бұрын

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

@power-of-bi 10 ай бұрын

That's a great question. Image width is a common property for all SVG images in the visual. But, in the SVG itself we can define view size that is smaller than Power BI visual image width. Then we can disable 'auto width' option in the visual and reduce the column width manually.

@MrAszpic 10 ай бұрын

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?

@malanam 10 ай бұрын

Deneb's more complicated to use, but would definitely be doable.

@power-of-bi 10 ай бұрын

Yes. See 11:00, I have the Deneb version of this chart. Deneb supports interactivity, custom tooltips. But you need to learn Vega or Vega-Lite and Deneb is a custom visual, while SVGs can be embedded into existing native visuals.

@beaglesandbunnies8952 8 ай бұрын

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!

@power-of-bi 5 ай бұрын

I've built an income statement with SVGs in a Matrix visual, but for now just a basic one, not a large ragged hierarchy with expandable rows. Regarding the hierarchies see www.daxpatterns.com/parent-child-hierarchies/.