Want to Upgrade Your Power BI Matrix into an Advanced IBCS Style Data Visualization? Here's How!
Вставка
- Опубліковано 23 лип 2024
- 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/ - Наука та технологія
10/10 this channel is taking off! 🙏🙏
I agree
Love this type of content with native (built in) Power BI visuals. ♥
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).
Brilliant work, giving both data position and direction! Thank you for sharing this.
Glad you enjoyed it!
Excellent work Sir! Thank you for sharing!
Fantastic work! 🙌
thank you sir! Much respect to your name 👏👏
Great. I already have Upgraded Matrix visual as Pivot Table available in Excel. Now let's further upgrade like this. Teach & Love learning
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!
I'm glad the video helped you! Thanks for the comment.
Absolutely brilliant. Really enjoyed your walk-through. Very clear. (Subscribed)
Thank you Tony!
New tips and tricks. Thank you
Good stuff, going to use this in my portfolio dashboard! Thanks for sharing.
You're welcome!
Excellent work, congratulations!
Thank you!
Amazing work!! Thank you for sharing
Thanks for watching!
This is immense, thanks very much!
Thank you! New video is coming:
ua-cam.com/video/q-90Cm_rp1w/v-deo.html
This is awesome work!
Thanks a lot!
I can't wait for it
Very great content 👍
Thanks for sharing
This is superb!!!
Thank you!
Great, thanks for sharing and explaining and the link to download the file.
Glad it was helpful!
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!
Thanks for the comment. Yeah, the FORMAT works differently depends on regional number formatting settings.
Extra! Super tip!
Glad it was helpful!
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!
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/.
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!
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).
@@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! ;)
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?
Deneb's more complicated to use, but would definitely be doable.
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.
Just curious if we can set the width of each chart separately. I want to set delta charts to half the width.
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.
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?
Use absolute values (not variance) to calculate scale ratio and then apply this scale to the absolute variance.
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?
Yes you can. See github.com/avatorl/Deneb-Vega/tree/main/ibcs-three-tier-chart
❤❤❤
Who achieved this customized table on powerbi, i need help asap