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!
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.
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 ,",",".")
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.
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 ❤❤
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 ???
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?
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.
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 !
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)
@@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
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.
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.
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
@@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
ctrl shift L -> th-cam.com/users/shortsI5HSerFTSDI 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 + ^
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
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
This is an excellent example of a professional using Ai to enhance projects. Love this!!!
😎👊 it makes life easier .. thanks for watching!
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!
Wow Great tip, thanks!
Unfortunately my ctrl shift L is tied to some graphics thing :(
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.
wow, customization at its peak here. you just always take BI to another level. hats off to you.
Another useful and interesting lesson... I love how you explain everything with detailed examples. Thank you very much!!!
This is the best SVG in Power BI tutorial I've ever had! You are the BEST, Bas! Mentor of the year!
🙌😎
Damn bro, Before your videos, I never knew we can do so much with power BI. Thank you man.
😎👊😊
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 ,",",".")
Good point!
This is amazing! I was looking for inspiration and now I have it! Thank you!
yey 🎉 happy it helped with getting a bit of inspiration 😊
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.
One thing for sure, AI would never be able to replace BAS.
hope my wife thinks the same 😅
Never say never. A 2 year old AI is already kicking butts imagine what it can do at 10.
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.
Wonderful alternative to KPI Matrix. Keep bringing more videos like this. Please bring videos every week
😊 thanks! I already do ;)
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.
Excellent! This take PBI to next level! Well explained. Thank you.
thanks 😊 yea svgs can come in handy at times
Just love the way you break down and test you DAX. Thanks for sharing 💥💥
ah lloooooot of testing 😁
My friend, I wanted to pause the video and leave a comment. You have a very different intellect. Congratulations. 😊
Thank you! 😃appreciate the kind words
You are great, a teacher, thank you very much for your teachings.
Thank you! 😃
I am so sorry for myself that I can't attend your course 😢😢, You are perfect in design powerbi , thanks for sharing your knowledge
It is amazing. Thanks!
Is it possible to build a stacked column/bar chart with SVG?
Amazing content! This opens up a world of possibilities!
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 👌.
One of the best tutorials ever done ❤
Love your content!
Your tutorials really helped me take my PBIs to another level!!
amazing! 😊 thx for watching the tutorials
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 ❤❤
have a whole training on that .... which takes a few days 😅
Thanks, that's great stuff! Make that kind of SVG Dashboard for your customer and nobody except you will be able to maintain it
thanks! I don't think you don't need to know much about svg to be able to maintain it.
SVG visuals has taken LinkedIn by storm. Too lazy to learn on my own, waiting for your video :)
Best SVG tutorial for real, big thanks for the effort ❤
That's a brilliant idea brother... As always...
Thank you for these wonderful videos...
Glad you like them! 😊 thx
Great work Bas, where i can find SVGs images like barcharts, whisker plots, etc to use in pbi please?
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!)
thanks for always watching the videos 😊don't worry about me :p I'm always relaxed, no need for vacation just yet
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 ???
Great video. You always surpass yourself. I'm excited about the content!
I appreciate that! thanks a lot😊
This is awesome. Brilliant job Bas! Thank you!
thank you!!! 😊
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?
This is great! Can you use this technique for infographics?
Awesome Bas, indeed always great tutorial!
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?
i didn't really run into performance issues. Maybe do some testing?
This is really next level. Love it! I can't wait to show of this new skill.
Have fun! 😊👊😎
Thanks Bas, for the video. Could you kindly tell me the name of the mic you use to record the videos?
Rode NTG4+ 😊
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.
Great videos. really like this. Great Job as alwasys
Wonderful, amazing! Thank you my friend!
😎👊
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 !
I love your videos man, great content
Glad you like them! thx 😊
Yo Bas ! you dream about this kinda stuff or what books you read Mate? This is excellent
THANK YOU! 😊😎👊 .. nah just playing around endlessly
WoW, thank you! Very informatic!
Glad you enjoyed it! thx for watching 😊
Amazing!
Thanks, you are the best
😊😎
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)
This is a very good idea
incredible, thank you for sharing BAS
thanks for watching again 😊
That's awesome 👌.. thanks for sharing🎉
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?
Great Video. Thank you :)
thanks 😊
OMG FANTASTIC
You are so god damned cool. You make me a better BI developer.
that's awesome 😎👊 great to hear that
Thank you for the video. Very cool!
Glad you liked it! 😊
Super bien explicado bro..
This is another Level 👏👏👏
😊 thx
Thank you so much
Thank you for this! 🎉
😎👊😊
Amazing.. Thank you.
Great video as always, very well explained.
you're always one of the first ones to comment , appreciate the support Wilco!
This is gold
thank you!! 😊
Hello Boss thank you for this interesting video my name is Souad and I am from Morocco
thx Souad , greetings from germany ;)
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 ?
This is amazing
thx!!!
Bas, do you happen to know why SVG’s don’t work after you add a calculation group to your model?
Sensational!!!
As always excelent
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.
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)
@@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
How can we add tooltip in the card visual?? On tht SVG column bar
Valeu!
Спасибо!
Hello, I want to know how you modifies the same variables at the same time at 15:11. Looking forward to your reply
Ctrl + shift + L
Can You make a tutorial of how We can add a excel sheet from OneDrive and add automatic refresh on it?
here you go :) th-cam.com/users/shortsGGHbbg6yi-A
Super video, thanl a lot
Glad you liked it!!! 😊
does it affect performance ?
👏👏👏
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.
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
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.
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
Can you please make a video on all important DAX functions
got a lot of vids about dax, check the dax playlist
@@HowtoPowerBI ok thank you so much brother I have never seen that playlist 😍
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
yea I explained that in the vid
Yeah you are always producing great videos. I learned lot form you. Thanks for your videos :)@@HowtoPowerBI
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
the video shows how to apply gradient
@@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
Bro any update on this
What i really want to know is how did you replace all of the [total sales] at once
ctrl shift L -> th-cam.com/users/shortsI5HSerFTSDI
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 + ^
@@HowtoPowerBI Literal gold! Thank you!
Can we sort text using DAX?
I know how to do manualy please help
th-cam.com/video/T6p5xy35UPE/w-d-xo.html
Just paste it in notepad > edit> replace all "" with '
This 1 will have > 100K views before christmas
ooeehh that's ambitious :p I hope you're right
😅 I don't think it is gonna happen
42K with 1.1k likes still not bad 😉. Something totally different - what are your views / experience with Inforiver?
: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
For me the image is not loading just the image icon pops up not the image
Any idea to solve this
oh really ? .. hmm .. also in thet example file from the video?
I did a svg and it’s not working with report builder
yes indeed, I think it doesnt work in report builder
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
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
Crack!!!
Hi,
Can you please send me the code
See download link in description
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
I use it quite a bit ,. hm sad to hear I couldnt convey the practical use case clear enough