Power Bi : Creating Dynamic SVG Visuals for a Dashboard

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 76

  • @allanp5
    @allanp5 Рік тому +1

    Thanks, that was really helpful. I wouldn't have thought of using SVG images for that.

  • @sricharang9537
    @sricharang9537 3 роки тому +4

    Great Stuff ! The flow is very detail.

  • @Inina12
    @Inina12 Рік тому +2

    THIS WAS AMAZING!! The exact step-by-step I needed

  • @jtpeace229
    @jtpeace229 3 роки тому +3

    Your channel content is a game changer👍 I made my dashboard show employee profile pic by watching your other video. Gonna implement this gender svg icon today. Thank you!

    • @DapperDash
      @DapperDash  3 роки тому +1

      Thanks for the support. In exchange for my content I need you to tell me what exercise I can do to increase my bench max. I am at 215 and the goal is 225lbs by the end of the month. lol

    • @jtpeace229
      @jtpeace229 3 роки тому +1

      @@DapperDash Sure thing! I'm no expert, but here is my 2 cents.
      1. Frequency is the key to increase your bench. Try to get 3~4 bench sessions per week.
      2. Incorporate bench press variations such as close grip bench press, Spoto press, pause bench press, and Larsen press.
      3. Train your stabilizing muscles by doing dumbbell bench press.
      Your weekly workout schedule will look something like this:
      Bench session 1: dumbbell bench press
      Bench session 2: Close grip bench press & body weight or weighted dips
      Bench session 3: Larsen press & Your normal bench press
      Bench session 4: Pause bench press or Spoto press
      For each exercise, do 4~5 sets. Pick a weight that you can only do 6~10 reps. Not too heavy, and not too light.
      Do the above bench sessions for 2 weeks (8 sessions total), then test your 1 rep max. Let me know if you have any questions!

    • @DapperDash
      @DapperDash  3 роки тому +2

      @@jtpeace229 just to give you an update. Hit 225 today. Thanks for the help

  • @joaorataoo
    @joaorataoo 3 роки тому +2

    Very good stuff and extremely well explained.
    Great work!!!
    Keep going.
    Thanks.

  • @garyb3455
    @garyb3455 Рік тому

    Awesome! You're giving me more hope that I could do more in Power BI. Cheers!

  • @danielmudie605
    @danielmudie605 3 роки тому +2

    Wow, that's awesome! There's so much potential with manipulating SVG images! You could include all of the geometric data in the model and combine it with the Play Axis custom visual to show animations all within Power BI! Nice work 👍

    • @DapperDash
      @DapperDash  3 роки тому +1

      Hey, if you ever end up creating any animations using SVG, let me know. I would be interested in seeing different ways that people utilize it within Power Bi. Appreciate the comment.

  • @ThepExcel
    @ThepExcel 3 роки тому +1

    Wonderful! Thx a lot

  • @yawowusu8543
    @yawowusu8543 3 місяці тому

    Awesome tutorials, gave me lots of ideas. Thanks a million

  • @eleftheriosioannidis2144
    @eleftheriosioannidis2144 2 роки тому +1

    Genius! Great tutorial well explained. Thank you

  • @miguelojeda2390
    @miguelojeda2390 3 роки тому +1

    Greaaat explanation !!! thank you very much, keep posting

  • @kunalr_ai
    @kunalr_ai 3 роки тому +2

    Thanks

  • @kirankumarav5217
    @kirankumarav5217 3 роки тому +1

    Wow learnt a new thing today😃 this will help me surely great content 👍

  • @PedroAnacletoOficial
    @PedroAnacletoOficial 2 роки тому

    this is mesmerizing, thank you so much! you are so bright.

  • @lauxlaux859
    @lauxlaux859 2 роки тому +1

    Thank you for making this video

    • @DapperDash
      @DapperDash  2 роки тому

      Thanks Rachel. Sorry if the video was difficult to see, it was my first video on the channel. Future ones should be more clear.

    • @lauxlaux859
      @lauxlaux859 2 роки тому

      @@DapperDash it was great! I understand wanting to improve but don't beat yourself up!

  • @schoolictservices2502
    @schoolictservices2502 Рік тому

    Thanks, great video very clearly presented and concise

  • @KMF7955
    @KMF7955 3 роки тому +3

    Really good walk-through. SVG's have so much potential. I wonder can you use this to show a bullet like chart in a table?

  • @maryampour8914
    @maryampour8914 Рік тому

    Wow! This is incredible 🤩

  • @ashishpawar1627
    @ashishpawar1627 2 роки тому

    You are the true master 🏆🏆🙌🙌🙌🙌

    • @DapperDash
      @DapperDash  2 роки тому

      I appreciate the kind words Ashish

  • @SANJIVRAI6693
    @SANJIVRAI6693 3 роки тому +1

    Just updating the tooltip with % values will look even better and replace the code that shows when you hover on the images

  • @ramakrishnaravula1819
    @ramakrishnaravula1819 3 роки тому +1

    Thank you for this vedio

  • @RamonCortes
    @RamonCortes Рік тому

    Simple and AWESOME!

  • @RichArd-ee2qj
    @RichArd-ee2qj Рік тому

    Hey Dapper Dash. Great vid. Haven't tried it yet but will. Comment / Question: when you were coding in Notepad ++ you cautioned against using the double quote ( " ). In PBI you created a measure with the code and updated the color using a hexidecimal color code. Did you use double quotes to update the color code? Looks like you did but the image quality on my screen made it hard to tell. Thx

  • @SocialMedia-io1tz
    @SocialMedia-io1tz 2 роки тому

    Awesome

  • @vaivelorum3335
    @vaivelorum3335 2 роки тому

    Impressive!

  • @ultimatejk496
    @ultimatejk496 11 місяців тому

    This is an incredible Tutorial. But I have a question, What should I do if I need the filling up of Mask from top to bottom,(like emptying the Cup)?
    please help me

  • @mangeshmehendale4139
    @mangeshmehendale4139 3 роки тому +2

    I was wondering if you have any sense of whats going on. My SVG images just dont render in Power BI. I downloaded a bunch of them and converted them into SVG compliant images by appending the usual syntax. When I push them out to a matrix or table, I keep getting the broken image icon. I am certain that I am not doing anything wrong based upon the following evidence. 1. image data renders properly using HTML viewer. 2. I have downloaded 4 SVG images of which 1 renders in the matrix - the remaining 3 dont. Each of the 4 have identical syntax to enhance the image data to SVG. Out of frustration I used the very same icon you are using from flaticon (male) , scooped up the image data, appended the SVG prefix and suffix and pushed it to a matrix. Nothing. The bizarre part is that 1 of the first 4 icons actually renders as an SVG image while the remaining 3 do not. Also, the same code used on the male icon image data on this video (downloaded from flaticon too) doesnt render as an SVG image. Have you encountered this issue earlier? Would you have any sense what I am doing wrong????

    • @DapperDash
      @DapperDash  3 роки тому +1

      Mangesh, I am not sure what is going on with your images. One difference between your data and mine is that my images are saved into a Dax Measure, while it sounds like yours are saved in a table as a column variable. I have not tried to work with svg inside of a table. If you are saving yours in a table, it may be better to use the image URL as opposed to the svg code in order to get the image to render. I don't believe that you would have the dynamic flexibility to alter the svg image in a table, as you would in a DAX Measure. Hopefully that makes sense.

    • @fashihahahmad9255
      @fashihahahmad9255 2 роки тому

      hi, my problem also like yours. how did you fix this?

  • @Data_Policy_Analytics
    @Data_Policy_Analytics Рік тому

    Thanks for the great video! how would you work with slightly more complex SVG images within Power BI that have multiple paths that are broken up in the code (e.g. d=)? Appreciate any insights!

  • @renatobf
    @renatobf Рік тому +1

    How can you do with Circular SVG? Ex: Circular Progresso Bar...

    • @DapperDash
      @DapperDash  Рік тому

      It should work exactly the same way. As a matter of fact, the male and female svg images shown are actually made up of two different parts. One is the body and the other is a circular svg that makes up the head. If you look closely at the svg code, you can see it is just a circle.

  • @dalto9139
    @dalto9139 3 роки тому +2

    Hello good afternoon! I followed all the steps, but when playing the filter, it does not execute the path. It is as if the formula does not run. Leaving the icon 100% filled. How can I solve?

    • @yami_anahi
      @yami_anahi 3 роки тому

      Could you fix it? I have the same problem.

    • @DapperDash
      @DapperDash  3 роки тому +1

      can you post the code to your svg image? I can take a look and see why it may not be running.

    • @wiambenmoussa6916
      @wiambenmoussa6916 3 роки тому +1

      @@DapperDash I'm facing the same problem too

    • @DapperDash
      @DapperDash  3 роки тому +1

      @@wiambenmoussa6916 can you post the code to your SVG measure and I can take a look

    • @wiambenmoussa6916
      @wiambenmoussa6916 3 роки тому

      @@DapperDash
      Male icone =
      //Define the % to be colored in:
      VAR percentageArea = DIVIDE('Effect'[TotalHommes],'Effect'[TotalFemmes]+'Effect'[TotalHommes])
      //Define the colors:
      VAR fillColor="#00477A"
      VAR backgroundColor="#cccccc"
      VAR Icon= "data:image/svg+xml;utf8,














      "
      Return Icon
      Thank you in advance :D

  • @ruchaysohawan4465
    @ruchaysohawan4465 3 роки тому +1

    Thank you for this, very well explained. Could this have been achieved using the Infographic Designer in Power BI?

    • @DapperDash
      @DapperDash  3 роки тому

      It is very possible. I have only used infographic designer a few times. I'm not 100% sure of all its capabilities. Definitely worth looking into. Thanks for the suggestion.

    • @jhdatascience
      @jhdatascience Рік тому

      Yes it could have and easier for non-technical users. Still good te learn how we can do it ourselves as infographic also has it's l limitations. Thanks for sharing!

  • @bestbes2
    @bestbes2 Рік тому

    Hi Man thanks for the tutorial, i have a qeustion it works in a new Pbix file but if i copy the code to my existing dashboard it ony works static. Where i refer to a measure in the icon code it doesnt work. If i make a new dashboard with the exact same code and data it does work. For the old dashboard i make a new page without any filters or anything

  • @carloszaldivar9371
    @carloszaldivar9371 2 роки тому +1

    Great! you’re a magician in the world of metrics.
    Could you help me? I have the icon but don’t change the percents. What is the problem?

    • @DapperDash
      @DapperDash  2 роки тому

      Hey Carlos. Can you provide me with your DAX code. I can see if i can help you out. My email is on the channel page, you can email me.

    • @carloszaldivar9371
      @carloszaldivar9371 2 роки тому

      @@DapperDash I didn’t find your email on your channel, I’ll appreciate if you let me know here. Thank you so much!

    • @DapperDash
      @DapperDash  2 роки тому

      @@carloszaldivar9371 dapperdash.bi@gmail.com

  • @ahmedmouafki2574
    @ahmedmouafki2574 3 роки тому +1

    thank you Sir i need your help to deal matrix in Power Bi How i can contact you thank again

    • @DapperDash
      @DapperDash  2 роки тому

      Ahmed, I apologize for the very delayed response. Hopefully you were able to figure out your problem. My email is on the channel page. You can email me with any questions, I would love to help.

  • @MPioker
    @MPioker 3 роки тому +2

    very good! could make model available for download?

    • @DapperDash
      @DapperDash  3 роки тому

      send me an email and I will send you the pbix file along with the data set

    • @DapperDash
      @DapperDash  3 роки тому +1

      @@valrhonafrance Thanks. I included a link in the description to a google drive where you can retrieve the pbix and excel file.

  • @ngocnguyen4616
    @ngocnguyen4616 Рік тому

    Hi, I edit the SVG file with Notepad ++. However , in Notepad ++, it not show the code in different lines as yours ( Everything just in one line)
    How to solve it?

    • @DapperDash
      @DapperDash  Рік тому

      Hey Ngoc, if you are working in a simple .txt file, you won't have the formatting that I have. Make sure you are opening the SVG file in Notepad++. Something that should also work is changing the language of the Notepad++ file to HTML or even XML. There is a "Language" menu at the top of Notepad++.

  • @elbezz
    @elbezz 2 роки тому +1

    Thank you! could you please increase the font size a bit, it's very hard to see!

    • @DapperDash
      @DapperDash  2 роки тому +1

      Yes, definitely. In other videos I have done, I made sure to zoom in. I did realize that it was difficult to follow using the full screen. If there was a particular section of code you needed, let me know.

    • @elbezz
      @elbezz 2 роки тому

      @@DapperDash Thank you very much indeed!

  • @ashleyow3298
    @ashleyow3298 2 роки тому

    do we need to use the table visual to display the SVG visual or can we use HTML Viewer visuals from the AppSource ?

    • @DapperDash
      @DapperDash  2 роки тому

      Ashley, I tested it out using "HTML Content" from the AppSource and it worked perfectly! It actually lets you adjust the size of the SVG.

  • @frenchmoneybags
    @frenchmoneybags 3 роки тому +1

    Might warn future viewers minor code knowledge required. Even if it is simple deleting.

  • @fabianobs10
    @fabianobs10 3 роки тому +1

    my name is Fabiano, I speak from Brazil. I tried to do according to the video but it didn't work. Could you give me your email so I can get in touch?

    • @DapperDash
      @DapperDash  3 роки тому

      dapperdash.bi@gmail.com
      Send me a copy of the code in your measure.
      Mándame una copia de el code que existe dentro de tu DAX measure.