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).
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!
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.
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! ;)
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/.
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?
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!
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.
10/10 this channel is taking off! 🙏🙏
I agree
This is amazing. What you call a true expert! 👏
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).
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.
Bosko. Wyrazy uznania również za porządek.
This is mind blowing, thanks for the content!
Great. I already have Upgraded Matrix visual as Pivot Table available in Excel. Now let's further upgrade like this. Teach & Love learning
thank you sir! Much respect to your name 👏👏
Fantastic work! 🙌
Good stuff, going to use this in my portfolio dashboard! Thanks for sharing.
You're welcome!
Brilliant work, giving both data position and direction! Thank you for sharing this.
Glad you enjoyed it!
Absolutely brilliant. Really enjoyed your walk-through. Very clear. (Subscribed)
Thank you Tony!
Excellent work Sir! Thank you for sharing!
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.
Thanks, great video, but no access to file
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
New tips and tricks. Thank you
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! ;)
Great, thanks for sharing and explaining and the link to download the file.
Glad it was helpful!
Amazing work!! Thank you for sharing
Thanks for watching!
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/.
Excellent work, congratulations!
Thank you!
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.
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.
I can't wait for it
Who achieved this customized table on powerbi, i need help asap
This is immense, thanks very much!
Thank you! New video is coming:
th-cam.com/video/q-90Cm_rp1w/w-d-xo.html
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.
Thanks for sharing
This is awesome work!
Thanks a lot!
Very great content 👍
This is superb!!!
Thank you!
Extra! Super tip!
Glad it was helpful!
❤❤❤