Building SVG Charts in Power BI

[@alex...g]

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]

Wow Great tip, thanks!

[@thefamousdjx]

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

[@gatorpika]

Also on Windows you can just use find and replace (ctrl+H) in Notepad. Paste the code in Notepad, hit ctrl-H, put " in find and ' in replace with then replace all.

[@DilbagSingh-vf6gv]

wow, customization at its peak here. you just always take BI to another level. hats off to you.

[@thatoneguy3661]

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

[@HowtoPowerBI]

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

[@meedow2319]

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

[@HowtoPowerBI]

🙌😎

[@umityalcin7888]

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

[@HowtoPowerBI]

Thank you! 😃appreciate the kind words

[@SpecialFX99]

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.

[@naveethsuraj6214]

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

[@HowtoPowerBI]

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.

[@abiduzzamanabid8221]

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

[@HowtoPowerBI]

😎👊😊

[@BrigadieruBrokastis]

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.

[@danishjameel6709]

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

[@HowtoPowerBI]

😊 thanks! I already do ;)

[@jaumeayala9581]

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

[@marcovlijm513]

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]

Good point!

[@SolidSnake59]

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

[@HowtoPowerBI]

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

[@FernandoMoreiraR]

Fantastic tutorial! Got enough info to make a live pipeline capacity chart in PBI, thank you!

[@just_pbi]

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

[@HowtoPowerBI]

thanks 😊 yea svgs can come in handy at times

[@victorsalaspsalas3119]

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

[@HowtoPowerBI]

Thank you! 😃

[@vineetpatel5698]

One of the best tutorials ever done ❤

[@mortezastat]

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

[@spen2431]

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

[@HowtoPowerBI]

ah lloooooot of testing 😁

[@kareemayman6704]

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

[@juniorsilva-v9e5s]

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

[@HowtoPowerBI]

amazing! 😊 thx for watching the tutorials

[@Thiago.M082]

Valeu!

[@Baldur1005]

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

[@yaynative]

Amazing content! This opens up a world of possibilities!

[@MrRobvanzutphen1]

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]

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

[@phoenixoo7]

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

[@HowtoPowerBI]

Glad you like them! 😊 thx

[@anilameer4595]

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 👌.

[@tofonofo4606]

This is awesome. Brilliant job Bas! Thank you!

[@HowtoPowerBI]

thank you!!! 😊

[@kukeleku13]

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

[@HowtoPowerBI]

Have fun! 😊👊😎

[@glassbone1]

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]

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

[@rlds07]

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

[@HowtoPowerBI]

I appreciate that! thanks a lot😊

[@dan.7997]

Awesome Bas, indeed always great tutorial!

[@risko1458]

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]

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

[@The-Data-Guru]

I love your videos man, great content

[@HowtoPowerBI]

Glad you like them! thx 😊

[@__HumanBeing]

Wonderful, amazing! Thank you my friend!

[@HowtoPowerBI]

😎👊

[@AMY-bq7qs]

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 ???

[@pabeader1941]

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.

[@anfiiiii]

Amazing! Thanks, you are the best

[@HowtoPowerBI]

😊😎

[@CrossSo]

This is another Level 👏👏👏

[@HowtoPowerBI]

😊 thx

[@unnikrishnansanthosh]

incredible, thank you for sharing BAS

[@HowtoPowerBI]

thanks for watching again 😊

[@NikoSuomiUlkoilee]

WoW, thank you! Very informatic!

[@HowtoPowerBI]

Glad you enjoyed it! thx for watching 😊

[@wilconagtzaam587]

Great video as always, very well explained.

[@HowtoPowerBI]

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

[@ОлегПетров-ю4п]

Thank you for the video. Very cool!

[@HowtoPowerBI]

Glad you liked it! 😊

[@ortj69]

Great tutorial. thx very much! It worked all perfectly, except for very last part. Trying to add svg to the new card visual doesn't work. Nothing is showing up, not even when I use the svg-Code without any calculations. The card visual remains empty. Mayby a bug with the current desktop version (November 2024)?

[@arbazahmad7177]

That's awesome 👌.. thanks for sharing🎉

[@TalhaIslam-f7t]

It is amazing. Thanks! Is it possible to build a stacked column/bar chart with SVG?

[@winsto4300]

Can data values ​​be added to the bar chart when hovering? Currently it only displays SVG code. Thank You

[@kunwang2279]

Great videos. really like this. Great Job as alwasys

[@BrendanHargie]

Thank you for this! 🎉

[@HowtoPowerBI]

😎👊😊

[@bostjanbrumec7174]

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]

This is a very good idea

[@FarhanKhan-lp3ds]

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

[@souadelghouzlani7560]

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

[@HowtoPowerBI]

thx Souad , greetings from germany ;)

[@souadelghouzlani7560]

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 ?

[@PhanindraGaddam-kt3hz]

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

[@HowtoPowerBI]

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

[@ShubhamDeshmukh-pi6rs]

does it affect performance ?

[@matthewdufty606]

Great Video. Thank you :)

[@HowtoPowerBI]

thanks 😊

[@juanignacioXI]

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

[@timothygallagher843]

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

[@HowtoPowerBI]

that's awesome 😎👊 great to hear that

[@mikemcknight317]

Amazing.. Thank you.

[@rezag.7349]

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?

[@dkoldt]

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 !

[@daXcel7448]

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

[@HowtoPowerBI]

Rode NTG4+ 😊

[@FrancizcoV]

Great video

[@rezaamini8580]

Thank you so much

[@natewohlgamuth78479]

This is gold

[@HowtoPowerBI]

thank you!! 😊

[@estebanherrera6669]

As always excelent

[@wilmarsg]

Super bien explicado bro..

[@庞焕坤]

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

[@HowtoPowerBI]

Ctrl + shift + L

[@yippiekyoo]

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]

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

[@halamehwish9969]

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

[@vani22542]

OMG FANTASTIC

[@natsarev]

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]

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]

​@@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

[@matheussvs]

This is amazing

[@HowtoPowerBI]

thx!!!

[@PetrMatsegora]

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?

[@henri9188]

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

[@diegolozano2397]

Super video, thanl a lot

[@HowtoPowerBI]

Glad you liked it!!! 😊

[@hariramkm1677]

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]

yea I explained that in the vid

[@hariramkm1677]

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

[@121balu]

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]

the video shows how to apply gradient

[@121balu]

@@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]

Bro any update on this

[@genevieve3676]

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

[@douglascory]

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

[@HowtoPowerBI]

ctrl shift L -> kzbin.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]

@@HowtoPowerBI Literal gold! Thank you!

[@ВикторСуханов-н3с]

Спасибо!

[@ramonAnalytics]

Sensational!!!

[@julieperron-rk5ys]

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]

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]

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.

[@Schaudhari0755]

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

[@HowtoPowerBI]

kzbin.info/www/bejne/imfTZquvaJqIhqc

[@abiduzzamanabid8221]

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

[@HowtoPowerBI]

here you go :) kzbin.infoGGHbbg6yi-A

[@mrutyunjayapradhan3599]

Can you please make a video on all important DAX functions

[@HowtoPowerBI]

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

[@mrutyunjayapradhan3599]

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

[@demitredacol]

👏👏👏

[@pbihari0214]

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

[@HowtoPowerBI]

yes indeed, I think it doesnt work in report builder

[@pk231]

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

[@HowtoPowerBI]

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

[@MrKhulaid]

Just paste it in notepad > edit> replace all "" with '

[@egbertdejong6377]

This 1 will have > 100K views before christmas

[@HowtoPowerBI]

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

[@HowtoPowerBI]

😅 I don't think it is gonna happen

[@egbertdejong6377]

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

[@HowtoPowerBI]

: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

[@shabeerahmed6891]

Hi, Can you please send me the code

[@HowtoPowerBI]

See download link in description

[@jorgesierra4916]

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

[@dhoopamramanjineyulu3392]

Hi I have interested to join your channel but i don't have money will you please help me i want to learn new things in power bi

[@josemariabetegon5171]

Crack!!!

[@pnr8uk]

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]

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