Building SVG Charts in Power BI

Рет қаралды 62,188

Күн бұрын

In this video I show how to get started with SVGs in Power BI. Step by step I go over how to build
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:56 Find and show a SVG as a normal Image
02:46 Display SVGs with measures
06:07 Creating your own svg charts - step 1
09:35 Set variables for SGV elements
10:32 Bind data to SVG elements
16:51 Adding a gradient fill color
19:35 Adding a fade in animation effect
22:43 Adding targets
28:51 Interactive SVGs
31:41 Showing a data series in a SVG chart
43:22 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZfaq: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX

Пікірлер: 152

@jaumeayala9581 Күн бұрын

Another useful and interesting lesson... I love how you explain everything with detailed examples. Thank you very much!!!

@naveethsuraj6214 8 ай бұрын

One thing for sure, AI would never be able to replace BAS.

@HowtoPowerBI 8 ай бұрын

hope my wife thinks the same 😅

@9jatechie Ай бұрын

Never say never. A 2 year old AI is already kicking butts imagine what it can do at 10.

@9jatechie Ай бұрын

I use AI as an exoBrain. I love the way Aai is deployed in this video. It shows the proper use of AI: as an assistant.

@thatoneguy3661 8 ай бұрын

This is an excellent example of a professional using Ai to enhance projects. Love this!!!

@HowtoPowerBI 8 ай бұрын

😎👊 it makes life easier .. thanks for watching!

@alex...g 8 ай бұрын

another quick tip to replace all of the double quotes: in pbi desktop if you highlight one of the double quotes then hit Ctrl+Shift+L it will replicate your cursor over every instance. Then you just type a single quote once and you're done! obviously this only works if you want to replace ALL of the same thing, but...saves some time most of the time!

@DuAuskenner 8 ай бұрын

Wow Great tip, thanks!

@thefamousdjx 4 ай бұрын

Unfortunately my ctrl shift L is tied to some graphics thing :(

@meedow2319 2 ай бұрын

This is the best SVG in Power BI tutorial I've ever had! You are the BEST, Bas! Mentor of the year!

@HowtoPowerBI 2 ай бұрын

🙌😎

@abiduzzamanabid8221 8 ай бұрын

Damn bro, Before your videos, I never knew we can do so much with power BI. Thank you man.

@HowtoPowerBI 8 ай бұрын

😎👊😊

@SolidSnake59 8 ай бұрын

This is amazing! I was looking for inspiration and now I have it! Thank you!

@HowtoPowerBI 8 ай бұрын

yey 🎉 happy it helped with getting a bit of inspiration 😊

@SpecialFX99 8 ай бұрын

10x more helpful than any other place on the web showing how to do this. Thanks! I'd love to see an example with a line chart. Not sure if I'll be able to get there on my own or not.

@MrRobvanzutphen1 8 ай бұрын

Awesome as always Bas!! Can't believe how often you keep coming up with new ideas and new videos! (Take some rest too bro, you deserve it!)

@HowtoPowerBI 8 ай бұрын

thanks for always watching the videos 😊don't worry about me :p I'm always relaxed, no need for vacation just yet

@danishjameel6709 8 ай бұрын

Wonderful alternative to KPI Matrix. Keep bringing more videos like this. Please bring videos every week

@HowtoPowerBI 8 ай бұрын

😊 thanks! I already do ;)

@user-bf9ov9ro1l 8 ай бұрын

Love your content! Your tutorials really helped me take my PBIs to another level!!

@HowtoPowerBI 8 ай бұрын

amazing! 😊 thx for watching the tutorials

@spen2431 8 ай бұрын

Just love the way you break down and test you DAX. Thanks for sharing 💥💥

@HowtoPowerBI 8 ай бұрын

ah lloooooot of testing 😁

@vineetpatel5698 8 ай бұрын

One of the best tutorials ever done ❤

@marcovlijm513 8 ай бұрын

Great video as always! Love your creative ways of using Power BI. Small remark: if you use different regional settings then the result of the variable for BarWidth could contain a comma separator in which case the calculation of barwidth doesn't work. You can solve this by using SUBSTITUTE for example: VAR BarWidth = SUBSTITUTE(( DIVIDE( [Sales Total] - _SalesMin , _SalesMax - _SalesMin ) + 0.05) * SVGWidth ,",",".")

@HowtoPowerBI 8 ай бұрын

Good point!

@just_pbi 8 ай бұрын

Excellent! This take PBI to next level! Well explained. Thank you.

@HowtoPowerBI 8 ай бұрын

thanks 😊 yea svgs can come in handy at times

@yaynative 8 ай бұрын

Amazing content! This opens up a world of possibilities!

@tofonofo4606 8 ай бұрын

This is awesome. Brilliant job Bas! Thank you!

@HowtoPowerBI 8 ай бұрын

thank you!!! 😊

@kareemayman6704 Ай бұрын

Best SVG tutorial for real, big thanks for the effort ❤

@kukeleku13 8 ай бұрын

This is really next level. Love it! I can't wait to show of this new skill.

@HowtoPowerBI 8 ай бұрын

Have fun! 😊👊😎

@victorsalaspsalas3119 8 ай бұрын

You are great, a teacher, thank you very much for your teachings.

@HowtoPowerBI 8 ай бұрын

Thank you! 😃

@rlds07 8 ай бұрын

Great video. You always surpass yourself. I'm excited about the content!

@HowtoPowerBI 8 ай бұрын

I appreciate that! thanks a lot😊

@phoenixoo7 8 ай бұрын

That's a brilliant idea brother... As always... Thank you for these wonderful videos...

@HowtoPowerBI 8 ай бұрын

Glad you like them! 😊 thx

@mortezastat 17 күн бұрын

I am so sorry for myself that I can't attend your course 😢😢, You are perfect in design powerbi , thanks for sharing your knowledge

@dan.7997 8 ай бұрын

Awesome Bas, indeed always great tutorial!

@__HumanBeing 8 ай бұрын

Wonderful, amazing! Thank you my friend!

@HowtoPowerBI 8 ай бұрын

😎👊

@The-Mo-Code 8 ай бұрын

I love your videos man, great content

@HowtoPowerBI 8 ай бұрын

Glad you like them! thx 😊

@unnikrishnansanthosh 8 ай бұрын

incredible, thank you for sharing BAS

@HowtoPowerBI 8 ай бұрын

thanks for watching again 😊

@arbazahmad7177 7 ай бұрын

That's awesome 👌.. thanks for sharing🎉

@NikoSuomiUlkoilee 8 ай бұрын

WoW, thank you! Very informatic!

@HowtoPowerBI 8 ай бұрын

Glad you enjoyed it! thx for watching 😊

@BrigadieruBrokastis 5 ай бұрын

what is this guy on? I have watched like 10 videos and each time I am surprised about what can you do with Powe BI. This is insane.

@user-ef4oc3vc6r 8 ай бұрын

Thank you for the video. Very cool!

@HowtoPowerBI 8 ай бұрын

Glad you liked it! 😊

@umityalcin7888 8 ай бұрын

My friend, I wanted to pause the video and leave a comment. You have a very different intellect. Congratulations. 😊

@HowtoPowerBI 8 ай бұрын

Thank you! 😃appreciate the kind words

@pabeader1941 8 ай бұрын

This is very helpful. I've been trying to create a visual that we can do in Excel but not in Power BI. I think this technique will make it possible. In Excel you can do things like changes the shape of a bar from an image. Like you can draw a picture of smoke and then use that instead of the plain rectangular bar. So it would look like bars of smoke. Then you can have an image in place of the data point. This means you could put in a image of a car. So you could have a bar chart that looks like a multi lane dragstrip with cars that have smoke trailing behind them. And even change the smoke to fire on the one that's in the lead. I think that might be possible with the information you provide here. I kinda did it in deneb, but it wasn't the same.

@wilconagtzaam587 8 ай бұрын

Great video as always, very well explained.

@HowtoPowerBI 8 ай бұрын

you're always one of the first ones to comment , appreciate the support Wilco!

@anfiiiii 8 ай бұрын

Amazing! Thanks, you are the best

@HowtoPowerBI 8 ай бұрын

😊😎

@Baldur1005 8 ай бұрын

SVG visuals has taken LinkedIn by storm. Too lazy to learn on my own, waiting for your video :)

@matthewdufty606 8 ай бұрын

Great Video. Thank you :)

@HowtoPowerBI 8 ай бұрын

thanks 😊

@BrendanHargie 8 ай бұрын

Thank you for this! 🎉

@HowtoPowerBI 8 ай бұрын

😎👊😊

@AMY-bq7qs 8 ай бұрын

Hey bas, u r amazing. I have been following you and watching your videos which helped me alot at places where simple solutions were not available. Can u please make a video on GIT Integration and CICD for power bi ???

@mikemcknight317 Ай бұрын

Amazing.. Thank you.

@glassbone1 8 ай бұрын

Thanks, that's great stuff! Make that kind of SVG Dashboard for your customer and nobody except you will be able to maintain it

@HowtoPowerBI 8 ай бұрын

thanks! I don't think you don't need to know much about svg to be able to maintain it.

@CrossSo 8 ай бұрын

This is another Level 👏👏👏

@HowtoPowerBI 8 ай бұрын

😊 thx

@anilameer4595 8 ай бұрын

Take notes 📝 Microsoft, you are not listening but Bas is and he is ahead of the timeline just like time travel..😮 This video is simply spectacular 👌.

@kunwang2279 8 ай бұрын

Great videos. really like this. Great Job as alwasys

@estebanherrera6669 8 ай бұрын

As always excelent

@PetrMatsegora 7 ай бұрын

Hello, Bas! Thank you for your video. But can you sort rows in the table using native pbi arrow of the column with svg content?

@rezag.7349 5 ай бұрын

Another great video by Bas. Is there a way to sort a SVG column in a Table visual, e.g. based on one of the values (measures) used in the SVG?

@vani22542 Ай бұрын

OMG FANTASTIC

@wilmarsg 6 ай бұрын

Super bien explicado bro..

@rezaamini8580 Күн бұрын

Thank you so much

@ramonAnalytics 3 ай бұрын

Sensational!!!

@user-eo2fg6rp5g 8 ай бұрын

Спасибо!

@yippiekyoo 8 ай бұрын

Great video Baz! Love the creative way you're doing your videos. How is the performance of the SVG Charts? I would imagine they're slow as the DAX code is long, right?

@HowtoPowerBI 8 ай бұрын

i didn't really run into performance issues. Maybe do some testing?

@FarhanKhan-lp3ds 6 ай бұрын

This is great! Can you use this technique for infographics?

@risko1458 8 ай бұрын

I hope you make a video or a playlist of a full project from start to end from data cleaning till how you will discuss the project with the client TYSM ❤❤

@HowtoPowerBI 8 ай бұрын

have a whole training on that .... which takes a few days 😅

@dkoldt 4 ай бұрын

Great content first of all! - I have a .. what might be a stupid question. To make the code more dynamic for purposes, i tried to create a variable for "Sales Total" and call the variable throughout instead. So that it can act as an interchangeable value depending on what i want to show. But that doesn't seem to work (the bars just level out) - is there something I am missing? Thanks !

@bostjanbrumec7174 8 ай бұрын

Very inspiring! Maybe it can be used to create an elbow arrow to connect two (or more) columns in a column chart (similar to thinkcell)

@CrossSo 8 ай бұрын

This is a very good idea

@natewohlgamuth7847 8 ай бұрын

This is gold

@HowtoPowerBI 8 ай бұрын

thank you!! 😊

@timothygallagher843 8 ай бұрын

You are so god damned cool. You make me a better BI developer.

@HowtoPowerBI 8 ай бұрын

that's awesome 😎👊 great to hear that

@juanignacioXI 5 ай бұрын

Great work Bas, where i can find SVGs images like barcharts, whisker plots, etc to use in pbi please?

@matheussvs 11 күн бұрын

This is amazing

@HowtoPowerBI 10 күн бұрын

thx!!!

@diegolozano2397 8 ай бұрын

Super video, thanl a lot

@HowtoPowerBI 8 ай бұрын

Glad you liked it!!! 😊

@daXcel7448 8 ай бұрын

Thanks Bas, for the video. Could you kindly tell me the name of the mic you use to record the videos?

@HowtoPowerBI 8 ай бұрын

Rode NTG4+ 😊

@natsarev 8 ай бұрын

Super as always! 🎉 SVGs are great to upgrade matrix visual. However I think to customise charts it's better to use deneb or something like that.

@HowtoPowerBI 8 ай бұрын

indeed, its nice for adding to a table/matrix or new card visual. Otherwise you probably better of with deneb (if your organization allows for custom visuals)

@scramiro1 7 ай бұрын

@@HowtoPowerBIcould we have a video explaining differences between different ways of creating custom visuals? I know about SVG, Deneb and charticulator... But which one to use? Pros and cons

@demitredacol 17 күн бұрын

👏👏👏

@halamehwish9969 8 ай бұрын

How can we add tooltip in the card visual?? On tht SVG column bar

@PhanindraGaddam-kt3hz 7 ай бұрын

Yo Bas ! you dream about this kinda stuff or what books you read Mate? This is excellent

@HowtoPowerBI 7 ай бұрын

THANK YOU! 😊😎👊 .. nah just playing around endlessly

@souadelghouzlani7560 8 ай бұрын

Hello Boss thank you for this interesting video my name is Souad and I am from Morocco

@HowtoPowerBI 8 ай бұрын

thx Souad , greetings from germany ;)

@souadelghouzlani7560 8 ай бұрын

I am beginner at Power BI and as I am disabled I am studing from home and working at the same time what can you advice me ?

@user-tq2zl2pd1t 5 ай бұрын

Hello, I want to know how you modifies the same variables at the same time at 15:11. Looking forward to your reply

@HowtoPowerBI 5 ай бұрын

Ctrl + shift + L

@henri9188 7 ай бұрын

Bas, do you happen to know why SVG’s don’t work after you add a calculation group to your model?

@abiduzzamanabid8221 8 ай бұрын

Can You make a tutorial of how We can add a excel sheet from OneDrive and add automatic refresh on it?

@HowtoPowerBI 8 ай бұрын

here you go :) kzfaq.infoGGHbbg6yi-A

@genevieve3676 6 ай бұрын

Excellent but despite having set as URL image, the image is not displayed into the grid or card... ==> I have a "greyed square with a default picture" but not the rocket - anyone has the solution to turn it into the rocket ? thanks

@julieperron-rk5ys 8 ай бұрын

Hi Bas, can you create a hotizontal bullet chart visualisation with native visuals. I would really love to know if you can achieve this without custom visuals.

@HowtoPowerBI 8 ай бұрын

yea thats possible, I've seen many example flying by in the recent 2 weeks so probably won't cover it until I found a unique angle

@julieperron-rk5ys 8 ай бұрын

Can wait to see how you can do it I havent seen anything go by that is a full horizontal bullet chart with previous year current year and target that can be conditionally formatted and sorted by any measure.

@trading_ka_chaska 8 ай бұрын

Can we sort text using DAX? I know how to do manualy please help

@HowtoPowerBI 8 ай бұрын

kzfaq.info/get/bejne/ipygaNuqmJu5gHk.html

@hariramkm1677 8 ай бұрын

I just done similar kind of visual on yesterday.. Slicer is affective SVG values and visuals. But there is no interaction when we click on SVG visuals

@HowtoPowerBI 8 ай бұрын

yea I explained that in the vid

@hariramkm1677 8 ай бұрын

Yeah you are always producing great videos. I learned lot form you. Thanks for your videos :)@@HowtoPowerBI

@mrutyunjayapradhan3599 8 ай бұрын

Can you please make a video on all important DAX functions

@HowtoPowerBI 8 ай бұрын

got a lot of vids about dax, check the dax playlist

@mrutyunjayapradhan3599 8 ай бұрын

@@HowtoPowerBI ok thank you so much brother I have never seen that playlist 😍

@121balu 8 ай бұрын

I want to know how we can add gradients for max to min values, eg:- 100 will be green and lowest with red color with 3 step colour

@HowtoPowerBI 8 ай бұрын

the video shows how to apply gradient

@121balu 8 ай бұрын

@@HowtoPowerBI in video gradients shown for single bar, however I need for complete chart eg:- if apple value is 100, mango value is 80, grapes value is 70, banana value is 30, cherry is 45 and blueberry is 10 then bar should be single colour however there will be 7 bars but colour should be gradients by max to low value

@121balu 8 ай бұрын

Bro any update on this

@douglascory 8 ай бұрын

What i really want to know is how did you replace all of the [total sales] at once

@HowtoPowerBI 8 ай бұрын

ctrl shift L -> kzfaq.infoI5HSerFTSDI Zooming: Ctrl + and Ctrl - Intellisense: Ctrl + Spacebar Insert New Line: Insert line below (with Indentation): Shift + Enter Insert line below (without Indentation): Alt + Enter Insert line above: Ctrl + Shift + Enter Indent: Indent line: Ctrl + ] / [ or TAB / Shift + Tab * Move / Copy Line: Move line up / down: Alt + Up arrow key / Down arrow key Copy line up / down: Shift + Alt + Up arrow key / Down arrow key Navigate / Select: Select all occurrences of current word: Ctrl + F2 or Ctrl + Shift + L Select next occurrence of current word: Ctrl + D Jump to matching bracket: Ctrl + Shift + \ * Go to row: Ctrl + G Insert cursor: Alt + Click Select current line: Ctrl + I Delete entire row: Ctrl + Shift + K Comment: Comment a line: Ctrl + / or Ctrl + K + C Uncomment a line: Ctrl + / or Ctrl + K + U Multi-Line comment: Ctrl + Shift + A *On Keyboard with German Layout: Indent line: Ctrl + ß / ´ Jump to matching bracket: Ctrl + Shift + ^

@douglascory 8 ай бұрын

@@HowtoPowerBI Literal gold! Thank you!

@pk231 8 ай бұрын

For me the image is not loading just the image icon pops up not the image Any idea to solve this

@HowtoPowerBI 8 ай бұрын

oh really ? .. hmm .. also in thet example file from the video?

@pbihari0214 8 ай бұрын

I did a svg and it’s not working with report builder

@HowtoPowerBI 8 ай бұрын

yes indeed, I think it doesnt work in report builder

@shabeerahmed6891 5 ай бұрын

Hi, Can you please send me the code

@HowtoPowerBI 5 ай бұрын

See download link in description

@egbertdejong6377 8 ай бұрын

This 1 will have > 100K views before christmas

@HowtoPowerBI 8 ай бұрын

ooeehh that's ambitious :p I hope you're right

@HowtoPowerBI 6 ай бұрын

😅 I don't think it is gonna happen

@egbertdejong6377 6 ай бұрын

42K with 1.1k likes still not bad 😉. Something totally different - what are your views / experience with Inforiver?

@HowtoPowerBI 6 ай бұрын

:p tell your boss that when you reached 42% of your sales target :D lol .. I don't have so much experience with the inforiver visuals so cant say

@josemariabetegon5171 6 ай бұрын

Crack!!!

@jorgesierra4916 7 ай бұрын

He didn't want to give me this simple example, do all the bars come out the same? Month,INGOPNETOS January,66402 February,154345 March,143422 April,81442 May,159283 June,213193 July,136032 August,193244 September,80407 October,249879 November,225217 December,505498

@pnr8uk 8 ай бұрын

That's a ridiculous amount of coding for practically zero reason. Love your content normally but this is a bit to OTT and really not much use in the real world

@HowtoPowerBI 8 ай бұрын

I use it quite a bit ,. hm sad to hear I couldnt convey the practical use case clear enough