Turn Any IMAGE into an INTERACTIVE VISUAL in Power BI

[@Aquaelus]

Every time a video comes out, I feel the vibes as a kid when I got presents.

[@HowtoPowerBI]

lol 😂

[@hi55us2]

I have finally found the Mr. Beast of power bi videos, such amazing content. My jaw dropped when you went through the list of maps and found the custom one on the bottom!

[@Missjuddy1]

I love your content and the way you teach. they are perfect with incredibly new information. I wish I could like them thousands of times :)

[@HowtoPowerBI]

Wow, thank you!

[@rasmusl8370]

Bas, your content and delivery is superb. Thank you!

[@jdisimoni]

I am so glad I found this channel. Taking PowerBI to the next level is such an important part of my teams role and every time a video comes out I instant share with my team. The work you do is incredible and has really helped my group show the data in a way that makes sense to everyone.

[@HowtoPowerBI]

thank you so much for the nice words! ☺😎👊

[@charlesrios8542]

I use QGIS a lot, but this is totally not what I typically use it for. Thank you. Awesome.

[@HowtoPowerBI]

Glad it was helpful Charles! How do you use QGIS? for me was/is a whole new world.

[@HachiAdachi]

🤯 I don't typically work with maps or geographical data, but I am going to have to somehow sneak this into my projects. All of them.

[@MarcoAntonio-yj4br]

Man you just overcome yourself with each video. This is dope, congrats!

[@HowtoPowerBI]

I appreciate that Marco! I was blown away when it worked, such opportunity for every report...

[@azlann7571]

(10:43) In my case, for the scale, I have to use multiply instead of divide to maintain the ratio, otherwise it the polygons displayed are distorted

[@HowtoPowerBI]

interesting, for me this one always worked - thx for sharing!

[@Davidstraub]

I love the way you explain everything in simple terms. I found this video quite useful.

[@sarakarakach7982]

Wonderful video, finally found an explanation how to do this. I only don't get why my image is totally different size than the one from that json: I have to fit them manually one on the other, result is never so good as on the video 😞

[@stefanoschantzis6939]

Amazing video. The details you shared are invaluable! Thank you!

[@HowtoPowerBI]

thanks Stefanos! happy it is helpful 😊

[@skeppers1976]

i was trying to do this last week with QGIS, but couldn't quite get it to the end. Bas, as always you are the guru at this. thanks for this awesome vid!

[@HowtoPowerBI]

Yea, qgis is a bit of a struggle at the beginning :) - hope this vid makes it a bit easier to make the necessary changes

[@skeppers1976]

@@HowtoPowerBI have already gone and finished it off due to your vid! your content is amazing.

[@anoitedfighter]

love it just impressed my manager with a map of the regions in BG, thanks a lot

[@premcst]

Thanks for the video Bas .. Learned a lot from your channel !!

[@nikotra]

This is an amazing trick and, as usual, a very well explained tutorial, I hope to use it ASAP, thank you for sharing :)

[@HowtoPowerBI]

Thanks Nicola! 😊

[@therealsirben]

Woow!! Great content, I'm learning how to PowerBi step by step

[@SuperAriel74]

Awesome! Thank you for that! It's amazing how you always find out those special tricks! Plz don't stop! ;-)

[@zuhebkhan6973]

Hi sir i thanks for your good content on power bi...i have learnt and got a power bi job in market

[@SolidSnake59]

I don't think there is one video you made that I didn't like. You make high quality stuff.

[@peterjolly4980]

Extremely helpful tutorial. I have been hunting for this and I really appreciate the detail you went into. Confident I can pull off something like this now.

[@davidwelsh293]

This is an amazing video! Showed me how to do everything I wanted to do to make a floor plan in Power BI. Thank you so much!

[@HowtoPowerBI]

Awesome 😎:) glad to hear this

[@kibromteweldemedhin4332]

All time best educational video! Thank so much!

[@EricaDyson]

Wow! Brilliant! What a great idea. Mega thanks for such a detailed and clear explanation. Well done!

[@jangelojr]

Fantastic. I used it on my dashboard today. Thank you.

[@AkibRahman-i5e]

Great video, thank you! I have a question: Is it possible to create a sub-area within “Menswear”? For example, “Menswear” would be the main category, and within it, there would be a sub-category called “Pant”. Both categories would be visible. If I click on “Pant”, it would display information related to pants. If I click on any other part of “Menswear” except “Pant”, it would show information related to menswear.

[@datactive859]

This is going to be very useful in my next dashboard. Please DO continue with these genius ideas

[@datactive859]

And I really appreciate the way you disclose the mistake and then correct it in the video.

[@Dylan-Harvey]

Thanks, this is exactly what I was looking for!

[@poluankireddy5904]

Hey Boss, I like all your videos and they are very useful to me, keep making more videos for me every day

[@HowtoPowerBI]

definitely will, thanks Polu

[@MrBasu-iq6md]

Please create a series on power bi charticulator. We are really missing visual customization options on power bi, unlike tableau.

[@alexcastas8405]

Brilliant Video! ... something i want to do is use part of this, to then geo-reference the image in a non-utm projection (so some local projection) and then overlay custom icons at specific location on that image. Is this possible? Maybe someone here has a link to similar? thanks.

[@florianpieront3296]

You are the Power BI GOAT 🐐🐐🐐

[@HowtoPowerBI]

Haha :) thx!

[@ericlee722]

Love this tutorial, can we have a video of the line chart with target for each category that you show in the video ???

[@pupycron4302]

My brain just melted. This is crazy cool.

[@officialjansent]

loved learning about this. thank you for making it so clear to follow

[@AnandDwivedi]

U presentation skill is amazing

[@HowtoPowerBI]

so nice to hear that, thanks Anand! 😊

[@juanignacioXI]

OMG this happens when Neo, uses Power BI, he crack the Matrix hahaha...Ty Bas that was awesome!

[@alex...g]

I am so thankful for you Bas! Amazing video - very useful info and great instruction as always.

[@ruchansezginal7036]

You are amazing! Thank you for sharing these awesome tips

[@abdulrahmanbaamer8624]

Great video as usual, question: function button is not appearing (for color).. Kindly advise what to do. Regards,

[@RAM-nm2dx]

Great channel, only missing the technique how to create a filter in a table to use the selection on the map.

[@itayhilel2168]

I tried do something similar with .svg but this is much better 😌 👌

[@raulsanchez3756]

OMG! A superb example and perfectly explained. Great job!!!!

[@HowtoPowerBI]

Thanks a lot Raul! Great to hear that 😀

[@benharris3129]

Might want to point out that one of the unique requirements for a topojson is that you cannot have overlapping polygons. Something to keep in mind when you make them. If I'm working with downloaded GIS data I usually apply a small negative buffer instead of trying to edit them out.

[@valapo80800]

Great Job Bas!!!! Sorry for my english but could you tell the name of aplication where the background is black where you translate the area for BI?

[@peterhelms-nielsen8838]

Great job! FYI you left out the video link regarding the DAX measure in the end of the video 😉.

[@HowtoPowerBI]

😊 thanks, hmmm .. it shows on desktop but not on mobile... not sure why yt does that. Anyways, here u go kzbin.info/www/bejne/rYW1o6ahht90fs0

[@hendrik-stack22]

Great video, I cant wait to use this technique for states in Germany :)

[@HowtoPowerBI]

for german states there is already a map you can choose from the dropdown :) so you don't have to go through all of that effort

[@juliom6260]

Jez. You are a genius. Thanks

[@itayhilel2168]

Great video, would love to see more examples of this

[@HowtoPowerBI]

Thanks! Have a look on Linkedin- just posted example on team structure www.linkedin.com/posts/datatraining-io_team-structure-in-power-bi-activity-6997886485211267072-BrML?

[@Adeyeye_seyison]

Amazing and superb content! Thanks a million sir

[@AninditaPutriPratiwi]

Hello, what's apps you use to convert topo jason text to readable syntax? Thankyou

[@EdinaMolnár-k5v]

Hi Bas! Thank you for all your videos. please, help me! :) I would like to have only the frame of the "departments" and have the objects itself being transparent. Not to hide fully the "floormap" with the unique "map". Do you have any idea how to resolve? Thanks

[@sarveshdeshpande1772]

Another great one ….. wonderful idea 💡

[@HowtoPowerBI]

Glad you think so Sarvesh!

[@dnyaneshwarbirajdar9237]

Can you also prepare a video on using SVG (subway image with path & station ) in power BI and animate the path based on status of the train (reached or not).

[@damionc]

Thank you for this solution. I find that an easier solution would be to use the synoptic panel custom visual. Also could use inkscape to create svg and then synoptic visual.

[@HowtoPowerBI]

great visual - though custom visual is not always an option

[@FabulousDjRichyS]

Synoptic user for a few years now... Synoptic is definitely easier, BUT lacks the control you have with this video's techniques. As consumers become savvier with Power BI, they will want functionality that Synoptic does not provide, namely Drill Through (no right clicking) and conditional formatting. Bas has converted me.

[@crowl6]

Nice! Thanks for sharing this, it's amazing. One question, can i reference two or more TopoJSON files?

[@ketanshah1389]

This is extremely cool. Awesome. Can we make it for Maps, village, district, state or election based map

[@mmcblues]

This is very useful though when i imported topjason i only got the polygons and not the image with polygon in the shape map

[@mmcblues]

Can we get the image underneath and polygons over it

[@HowtoPowerBI]

Overlap a normal image with the shape map

[@LogicQuest]

That's pure magic..

[@evangelosrekleitis1641]

Nice video. The colouring using measures was brilliant, didn't know you could this. There plugins in QGIS both for drawing rectangles and ovals, and for directly exporting topojson.

[@renealvarezm]

Awesome video. Thanks so much for sharing.

[@HowtoPowerBI]

Thx Rene!

[@lijunchen]

Very informative tutorial. I have a question. How is the original background image created?

[@stevannsevellec1447]

Thanks a lot for this howto. but HELP, I can't figure out why the transparency with this measure doesnt work for me... Can anyone help me ?

[@uyu96]

Another great one vid!

[@marcing3364]

thanks Bas for content and knowledge you share. I am just wondering if using Synoptic Panel (Custom viz created by OKViz) can solve this problem easier and faster? It allows user to upload picture and mark hot spots in the picture (in example small squares), theen you can add conditional formatting to change fill based on measure

[@rasmusl8370]

Interesting. Thanks for sharing! Bas did make the point that his aim was to do this without custom visuals :)

[@marcing3364]

@@rasmusl8370 without custom visuals, not it makes sense to use Bath's path :)

[@tessnimneji8165]

So so interesting :D good job

[@legendgod]

Can you show the location names on the map (the topojson) directly?

[@HowtoPowerBI]

hm, i would do it on the labels of the overlaying visual .. Not sure if it is possible to add them to topojson

[@briancasson8396]

This is fantastic

[@unnikrishnansanthosh]

excellent, thanks for sharing BAS

[@vishalnasre1251]

Thanks bas for beautiful video

[@rafeehelmy4405]

U r amazing man, thank u

[@a7mad2002]

I have maps from ArchGiS converted to topojson directly, also I have the exact information generated by Json , however, the Shapmaps show it that very distortion. How can I fix that . I'd very much appreciate it if we could have a direct connection to explain that in more. detailed

[@firstch7801]

This one is amazing guide , really love it.

[@HowtoPowerBI]

Thx for watching! 😀

[@TBGM855]

Can you create a strategy map like this?

[@philc787]

Great content. Great beard too

[@gondebas]

Hi! Respect! Thank you🙂

[@eugenekim4523]

I have a good suggestion for your next video: How to bring in a customized reference layer such as a polygon as a boundary to filter just the data points within it. I went through youtube, stackoverflow, arcgis and microsoft forums, and documentation and none of these places do not have an answer

[@muzniahamed5887]

How to incert new row in power query

[@pritampaul5115]

Amazing Video!

[@rodrigorodriguezpaulino7856]

Is there a way to create a map using Nodejs, Typescript and Pbiviz? :O

[@yueyin6071]

wow superb creative guru

[@HowtoPowerBI]

Thanks 😊

[@harikumarpalapparambil6653]

Can you please share a video, how to make chart similar to Gant chart with a time slot of 1 hr with a duration of an activity. Like employe login / logout ( date time column). Is there any chart which can plot hour slot duration of an activity, like a Gant chart in bi.

[@Dalboni]

Awesome!

[@noorkhresat999]

Can i add a picture as a background?

[@luisfernandomacedo1451]

Great job, Sir!

[@HowtoPowerBI]

Thank you Luis!!

[@kumarvg5383]

Superb content 👌 👏 👍

[@HowtoPowerBI]

Thank you Kumar 😀

[@zuhebkhan6973]

Thanks in advance

[@szklydm]

FanBAStic!

[@fatiga2426]

Excelent thank you

[@HowtoPowerBI]

Thanks for watching 😀

[@lucasshipsides1510]

awesome!

[@zuhebkhan6973]

To show min sale date in a month only date i need to show...tried will all Google but not achievable...plse help me to save my job

[@م.محمودالبرق]

Dear Sir I am looking easy way to create geographical json map , Could u help me

[@eldrigeampong8573]

Very informative video

[@HowtoPowerBI]

Great to hear that, thanks Eldrige

[@henripasaribu2467]

How to view pdf file on Power BI ?

[@ttpryor]

I have tried to follow the directions you have provided more than once and got the same result. The custom map has no shapes? help me Obi-Wan

[@gersafriyie]

That's great BAS

[@HowtoPowerBI]

thank you Afriyie! 😊

[@zuhebkhan6973]

Sir as in this journey from past 5 months...now there is requirement from my client

[@amrselim2167]

can we do that on power bi RS for report server sir?!! i'm you biggest fan, love you man!

[@HowtoPowerBI]

I think if you upload the pbix file it works in rs 😀 thx for watching Amr

[@HaoCui-up1dp]

It’s actually very nice, but looks like very similar to treemap. And a bit complex for new user

[@andreanikitacavaletti9761]

great