Creating custom visuals in Power BI with DAX

Поделиться
HTML-код
  • Опубликовано: 22 дек 2024

Комментарии •

  • @kukeleku13
    @kukeleku13 2 месяца назад +16

    Beautiful explanation. I appreciate the disclaimer of considering the amount complexity you're adding to the report. It's not all about showing your skills. It's about adding value to the business.

    • @KurtBuhler
      @KurtBuhler 2 месяца назад +1

      💯 definitely. Utility and quality above all.

  • @jeffweir9358
    @jeffweir9358 2 месяца назад +11

    Outstanding video, Kurt. Incredible to see you build this in realtime. I was expecting you to say "SVG is simple, but not easy" though. :-)
    I've played around with SVG Sparklines before, allowing me to have filled sparklines (which are much easier to read given the fill provides a baseline) and at the same time building in a dynamic option to let users choose whether they are scaled individually or as a group. I've been banging my head on Power BI's native databars of late - bemoaning their lack of conditional formatting or the ability to scale databars in different columns relative to each other. This reminds me that I have the power to build what I want, rather than holding my breath for MS to come to the party.
    Thanks for the inspiration. Loving seeing SQLBI content focused at the whole point of DAX...to help users make smarter decisions with less pain.

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      Thank you jeff!!!

  • @adelsassi1531
    @adelsassi1531 2 месяца назад +3

    I'm learning D3.js and your tutorial just broadens my vision of how creating custom visuals for Power BI. Thank you Kurt!

  • @Kraazy4u
    @Kraazy4u 2 месяца назад +4

    Thanks for sharing! I’m really looking forward to future Power BI updates that will make custom visualizations much easier. This feature will be a real game-changer for our data presentations!

  • @GaganDeep-hb2xu
    @GaganDeep-hb2xu 2 месяца назад +8

    What an explanation! SQLBI never ceases to impress. 🙂

  • @emilmubarakshin49
    @emilmubarakshin49 2 месяца назад +2

    SQLBI does it again! Absolutely love the video and certainly appreciate the consideration of the trade offs involved. And thanks for the post credits :)

  • @HachiAdachi
    @HachiAdachi 2 месяца назад +6

    Had NO idea you could animate SVG... 🤯 Thank you for this fascinating intro to SVG custom visual, Kurt!

  • @tmaris
    @tmaris 2 месяца назад +3

    Great explanation and the best implementation of SVGs in PowerBI I've seen! Thank you Kurt!

  • @jginty
    @jginty 2 месяца назад +2

    Thank you for this video. It provides a great overview of the different approaches to enhancing visualizations. The review of the pros and cons of each method was very helpful.

  • @John14_
    @John14_ 2 месяца назад +2

    This is very helpful. I did not realize Deneb was a thing nor did I know you could take this SVG approach. I hope more videos will be put out on this topic as I'm very deficient when it comes to the design aspect for Power BI.

  • @JapjeetS
    @JapjeetS 2 месяца назад +2

    Thank you for a very detailed video. Its always good to know techniques we can use when nothing else seems to be working and is the best way to share the information.
    Its complicated for sure but definately has its own usecase scenarios too

  • @gauravguliani358
    @gauravguliani358 2 месяца назад +2

    You're remarkable! Thanks for producing gold standard material each time

  • @Ju4n_R0j0
    @Ju4n_R0j0 2 месяца назад +2

    Thanks, Kurt!! This, as all of your videos, is gold! I' also a big fan of the MacGyvering method..

  • @akashgupta4081
    @akashgupta4081 2 месяца назад +2

    Nice explanation, as expected. True gem for working professionals

  • @Rodrigo-od1dk
    @Rodrigo-od1dk 2 месяца назад +2

    Awesome video as always! I needed that overall take on the possibilities when not using standard visuals. Thanks!

  • @smilyhemant
    @smilyhemant 2 месяца назад +2

    Just awesome. I agree that we need to consider the time taken to build the visual and it's actual impact on the report. But it is really nice to have it as a side project

  • @DoThePoint
    @DoThePoint 2 месяца назад +2

    Very interesting and well put together as always. Thanks Kurt!

  • @KNP-BI
    @KNP-BI 2 месяца назад +3

    High quality as always Kurt! Love the ending. 🤣

  • @jelithompson
    @jelithompson 2 месяца назад +6

    Just when I think I’m getting good at something, I discover I know nothing. I definitely would have tried to use a built in visual and it would halfway work (which means it doesn’t really work). Thanks for the information, sparking some ideas, and for keeping me humble.

  • @mwaltercpa
    @mwaltercpa 2 месяца назад +2

    This blows my mind! My marketing mgr. jokes that he wants blinking good/bad icons… I might just surprise him w this. I’m giving this a go. Thanks Kurt! 😊

  • @andresramirezortega6218
    @andresramirezortega6218 2 месяца назад +2

    This svg custom visual just blows my mind!!!

  • @officesuperhero9611
    @officesuperhero9611 2 месяца назад +1

    This is an amazing tutorial. A real game changer! Thank you for sharing this.

  • @naylord5
    @naylord5 2 месяца назад +2

    This is pure gold! Thank you so much for sharing

  • @carloserodriguez2465
    @carloserodriguez2465 2 месяца назад +2

    Thank you so much for this explanation it was very helpful to understand the basic and the standard approach to work with this visual.

  • @jenniferyepez1947
    @jenniferyepez1947 2 месяца назад +2

    New subscriber! It's insane all the things you're able to do with Power Bi. Will apply this soon :D

  • @sidneyjenkins1218
    @sidneyjenkins1218 2 месяца назад +2

    Great job!! Please share more videos on the SVG approach and animation techniques. Very very helpful!! Thank you! 😄

  • @LegendaryBullStrike
    @LegendaryBullStrike 2 месяца назад +2

    Awsome learning content in here!
    I just would like to point out, that with Python/R visuals, you have some more limitations that you have to take into account besides the ones Kurt mentioned.
    Specifically, if you intend to serve the visual for a large audience via PBI Service, take into consideration that Python/R visuals can only be deployed via a Personal Gateway, which can be a constraint in larger organizations that use Enterprise Gateways to update PBI report in the Service.
    Cheers!

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      Python/R visuals don't require a personal gateway, actually! That only applies when you use Python/R integration in Power Query. This may differ depending on the configuration of your visual, but generally, that's how it works. Also, you are limited in terms of what libraries are supported.

  • @acunarro
    @acunarro 2 месяца назад +2

    Great video and explanations! Thanks for sharing
    Greetings from Uruguay!

  • @JenyKoch
    @JenyKoch 2 месяца назад +2

    That is a very nice and realistic explanation. with lots of examples

  • @VeganSmasher
    @VeganSmasher 2 месяца назад +2

    Dude, this is PFM. Thank you!

  • @emma9427
    @emma9427 2 месяца назад +2

    Great video! All the steps are clear and really helpful! 😁

  • @Qweertyyuiiop
    @Qweertyyuiiop 2 месяца назад +2

    that was amazing, i cant wait to see what people start coming up with

  • @nejhadehyarollahi4735
    @nejhadehyarollahi4735 2 месяца назад +2

    Amazing stuff, I just enjoyed every bit of the video. thanks a lot.

  • @SirTupsAlot
    @SirTupsAlot 2 месяца назад +2

    Great stuff! Thanks so much. Looking forward to trying this out.

  • @Kukuletz
    @Kukuletz 2 месяца назад +2

    Very good explanation, both of the advantages and disadvantages of using SVGs in DAX. I am sometimes using Deneb for specific customer visualizations i need, would love to see a video on best practices for those.

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      More on Deneb in probably January or December.

  • @pauljonze
    @pauljonze 2 месяца назад +3

    Great video, really informative. If the range of values isn't too large it could maybe even be possible to put all the progress svg schemas in a table and then index them to change depending on the value being referenced

  • @pawlowski6132
    @pawlowski6132 2 месяца назад +3

    Fascinating. I'll be working on this this week. Any chance someone could pause and drill down on the technique or method for escaping the double quotes? That went a little fast and I don't know if I would be able to reproduce that step or technique based on this video.

    • @KurtBuhler
      @KurtBuhler 2 месяца назад +1

      Sorry for that, you can either use find/replace in tabular editor or you can highlight it and press Ctrl+D in the dax formula bar to select the next occurrence of the highlighted text

  • @DavidPesante
    @DavidPesante 2 месяца назад +2

    Great video... really appreciated. Great explanation. One observation with respect to this approach and the MacGyver approach is that usually they require a lot of DAX measures to get them to work. Have you done a performance comparison between this approach and say using Deneb which would only require the original DAX measures and not the other measures you end up creating to support the dynamic aspect of the visual. Any thoughts on this?

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      Generally depends cant say anything that applies to all situations but overall youre right that deneb keeps the model cleaner and has less object overhead.

  • @lucasszymkowiak6765
    @lucasszymkowiak6765 2 месяца назад +2

    Thanks for the clear explanation!

  • @DeronHuskey
    @DeronHuskey 2 месяца назад +2

    Wonderful demo!

  • @deepakbhatta07
    @deepakbhatta07 2 месяца назад +2

    Super helpful video ! Can you please mention the tool you are using for annotating on screen ?

    • @nelsoncruzg
      @nelsoncruzg 2 месяца назад

      Looking for the same! I usually screenshot and annotate the screenshot, not great

  • @alexcastas8405
    @alexcastas8405 Месяц назад +1

    This is really good info, I’m going to try it for a project I got coming up now. Thx

  • @fUlViOMavaracchio
    @fUlViOMavaracchio 2 месяца назад +2

    This is amazing! Thanks Kurt, ciao.

  • @louwjhl7227
    @louwjhl7227 2 месяца назад +2

    Wow, that is next level!

  • @spen2431
    @spen2431 2 месяца назад +2

    Wow... 🤯🤯 - Thanks for sharing

  • @zakarie
    @zakarie 2 месяца назад +3

    what drawing tool are you using?

  • @Kurtosis3
    @Kurtosis3 2 месяца назад +2

    Thank you for that great tutorial! Could i ask which design tool you used to visualize the concept at start?

  • @victorionescu7653
    @victorionescu7653 2 месяца назад +2

    Thanks, very good presentation!

  • @MalvinCleoSabillo
    @MalvinCleoSabillo 25 дней назад +1

    thanks sir, I have a question please. Will it takes more time to load if I will do this and will be handling 50 - 60 millions of rowsand 10-20 columns of data? THank you my good sir

  • @arimaelg7793
    @arimaelg7793 2 месяца назад +2

    Great Tutorial!

  • @markusoestreich8695
    @markusoestreich8695 2 месяца назад +2

    I wish you would have shown also Deneb a little bit ... but great video thanks

  • @manthanmistry1205
    @manthanmistry1205 2 месяца назад +1

    That was very helpful Kurt. What platform do you use while explaining? Those handwritten text looks awesome ❤

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      Figma // FigJam IIRC :) Thanks

  • @edgards
    @edgards 2 месяца назад +2

    Thanks for sharing this tutorial

  • @antoniodamore
    @antoniodamore 2 месяца назад +2

    Bellissimo video, apre scenari di personalizzazione molto interessanti.

  • @olbu
    @olbu 2 месяца назад +2

    Great Video! Many thanks!

  • @David863006
    @David863006 2 месяца назад +2

    Ich liebe SVG in PowerBI. Man kann echt schönes Zeug damit machen❤.

  • @davidoj519
    @davidoj519 Месяц назад

    Awesome article! some months ago i was searching like this! i use it with moderation! xD

  • @dangnguyen5465
    @dangnguyen5465 2 месяца назад +2

    Very useful. Thank you

  •  2 месяца назад +1

    Great!!! Thank you so much!! ♥

  • @KA-rk9to
    @KA-rk9to 2 месяца назад +2

    Hey interesting stuff
    What’s the shortcut to select and escape out?
    Br

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      Ctrl+D to select next occurrence of highlighted text. I have a script to do this in TE2/3

  • @GaryThomann-CoGC
    @GaryThomann-CoGC 2 месяца назад +1

    not only does kurt code on the fly ... but creates tunes on the fly ... nice outro bro :}

  • @joeachakji
    @joeachakji Месяц назад +1

    very nice! I might try to use this

  • @patrickharilantoraherinjat2994
    @patrickharilantoraherinjat2994 2 месяца назад +2

    Just amazing... thanks

  • @mienzillaz
    @mienzillaz 2 месяца назад +2

    Brilliant. Will there be part two for Deneb? 😅

    • @KurtBuhler
      @KurtBuhler 2 месяца назад +1

      We will definitely be covering deneb in more deets later

  • @oriby1
    @oriby1 2 месяца назад +2

    Hi, how did you make this on time stamp blink?

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      You will have to search and read about "svg animation " its a sizable topic but theres good docs out there

  • @ankitsharma1943
    @ankitsharma1943 2 месяца назад +2

    loved your videos

  • @김차수-k2u
    @김차수-k2u 2 месяца назад +2

    Amazing!!

  • @ginaramirez2313
    @ginaramirez2313 2 месяца назад +2

    thanks for the video!

  • @strafanich
    @strafanich 2 месяца назад +6

    the post-credits scene had me laughing audibly :D

  • @druthorah
    @druthorah 2 месяца назад +2

    The Important Message at the end ✅️ 😂

  • @trulli777x
    @trulli777x 2 месяца назад +2

    Pretty cool!

  • @TomGee-n1n
    @TomGee-n1n 2 месяца назад

    Hi - Not related to this vid but I'm hoping you can help!
    I'm trying to come up with a way to conditionally format the value of a calculation item that exists only inside of a calculation group when displayed in a matrix.
    My calc group is simple - it has three calculation items. The value of the selected measure for the last N days, the value of the selected measure for the previous N days, and then the third calculation item compares the last N days (user selectable) of the selected measure to the previous N days and reports the difference as a percentage. What I need to find a way to do is to format that percentage as a red font or a red shaded background in the matrix if it is a negative value. Ideally yellow for slightly negative and red for neg values beyond a threshold.
    I found your vid that explains something similar, but it is based on the name of the selected measure. What I need to do is conditionally format based on the value of the calculation item that exists only inside the calculation group which then is shown in a matrix.
    Any suggestions!?

  • @hi_vishy
    @hi_vishy 2 месяца назад +2

    Very honest❤

  • @3rjc11
    @3rjc11 2 месяца назад +2

    When you PowerBI in god mode. This blew my mind

  • @KatWheeler-z5f
    @KatWheeler-z5f Месяц назад +1

    So cool!!

  • @LavKK1998
    @LavKK1998 2 месяца назад +2

    That is crazy usefull.

  • @LavKK1998
    @LavKK1998 2 месяца назад +2

    crazy usefull.

  • @tchaitow
    @tchaitow 2 месяца назад +3

    love the last 10 seconds!!! hahah

  • @hongyangtan9897
    @hongyangtan9897 2 месяца назад +2

    Great!

  • @AbhishekSharma-dn5us
    @AbhishekSharma-dn5us 2 месяца назад +2

    Haha Good one at last !

  • @jimmydaddy7
    @jimmydaddy7 2 месяца назад +2

    I know what that outro song is!

  • @kot23
    @kot23 2 месяца назад +3

    Comments in DENEB?? Since when? :)

  • @debug943
    @debug943 2 месяца назад +2

    Deym!

  • @jonglassmusic5813
    @jonglassmusic5813 2 месяца назад +2

    How’s this look in 2024?

  • @Julian-w1k9v
    @Julian-w1k9v 2 месяца назад +4

    I demand Italian accent

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      Beepity boppity boopity ima kurt hello - here you go

  • @1yyymmmddd
    @1yyymmmddd 2 месяца назад +3

    Not that complicated, just many things have to be taken care of. Would have loved Figma part explained in more detail.

    • @KurtBuhler
      @KurtBuhler 2 месяца назад +1

      More coming on figma...

    • @JBartlett_DMU
      @JBartlett_DMU 2 месяца назад

      @@KurtBuhler Any chance you'll demonstrate this technique with a FOSS SVG app like Inkscape? Some of us don't have Figma and won't be getting it any time soon.

  • @Master_of_Antares
    @Master_of_Antares 2 месяца назад +2

    Look guy with long hair, you need to stop talking about customers, and start making reports about D&D. Don’t think we didn’t see those sneaky minis creapin up on you in the background. 😂

  • @qaz56q
    @qaz56q 2 месяца назад +5

    Fascinating, but unfortunately not useful for many companies in the long term. Even if current staff can handle this approach, there is no guarantee that a new developer will also maintain it. (In the scenario where the previous one resigned from the job)

    • @KurtBuhler
      @KurtBuhler 2 месяца назад

      This is true and an important consideration we also mention in the video/article! Nonetheless important to know the available options.

  • @extraktAI
    @extraktAI 2 месяца назад +2

    Great!