Turn Any IMAGE into an INTERACTIVE VISUAL in Power BI

Подписаться 224 тыс.

Просмотров 98 тыс.

50% 1

In this video I show you how to turn any image into an interactive visual using the native shape map in Power BI. Step by step you'll learn how to create a custom map using QGIS (a free tool) and how to adjust it to work within Power BI. With a few DAX tricks you can set the colors and transparency you want for each area.
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
02:35 Creating a custom shape map in QGIS
08:02 Convert geojson to topojson
09:00 Adjusting the map to work in Power BI
11:32 Using a custom map in the shape map visual in Power BI
14:20 Using a measure to apply color and transparency
17:38 Apply a gradient to areas
18:42 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 RU-vid: 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

Наука

Опубликовано:

4 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 144

@Aquaelus Год назад

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

@HowtoPowerBI Год назад

lol 😂

@rasmusl8370 Год назад

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

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

@Davidstraub Год назад

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

@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! ☺😎👊

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

@alex...g Год назад

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

@EricaDyson Год назад

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

@officialjansent Год назад

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

@stefanoschantzis6939 Год назад

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

@HowtoPowerBI Год назад

thanks Stefanos! happy it is helpful 😊

@jangelojr Год назад

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

@premcst Год назад

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

@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

@Dylan-Harvey 17 дней назад

Thanks, this is exactly what I was looking for!

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

@ruchansezginal7036 Год назад

You are amazing! Thank you for sharing these awesome tips

@SuperAriel74 Год назад

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

@raulsanchez3756 Год назад

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

@HowtoPowerBI Год назад

Thanks a lot Raul! Great to hear that 😀

@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! 😊

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

@therealsirben Год назад

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

@kibromteweldemedhin4332 Месяц назад

All time best educational video! Thank so much!

@anoitedfighter Год назад

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

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

@uyu96 Год назад

Another great one vid!

@Adeyeye_seyison Год назад

Amazing and superb content! Thanks a million sir

@unnikrishnansanthosh Год назад

excellent, thanks for sharing BAS

@pritampaul5115 Год назад

Amazing Video!

@vishalnasre1251 Год назад

Thanks bas for beautiful video

@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

@rafeehelmy4405 Год назад

U r amazing man, thank u

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

@juliom6260 Год назад

Jez. You are a genius. Thanks

@firstch7801 Год назад

This one is amazing guide , really love it.

@HowtoPowerBI Год назад

Thx for watching! 😀

@tessnimneji8165 Год назад

So so interesting :D good job

@Dalboni Год назад

Awesome!

@sarveshdeshpande1772 Год назад

Another great one ….. wonderful idea 💡

@HowtoPowerBI Год назад

Glad you think so Sarvesh!

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

@renealvarezm Год назад

Awesome video. Thanks so much for sharing.

@HowtoPowerBI Год назад

Thx Rene!

@gondebas 11 месяцев назад

Hi! Respect! Thank you🙂

@lucasshipsides1510 Год назад

awesome!

@luisfernandomacedo1451 Год назад

Great job, Sir!

@HowtoPowerBI Год назад

Thank you Luis!!

@briancasson8396 Месяц назад

This is fantastic

@zuhebkhan6973 Год назад

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

@pupycron4302 Год назад

My brain just melted. This is crazy cool.

@LogicQuest Год назад

That's pure magic..

@fatiga2426 Год назад

Excelent thank you

@HowtoPowerBI Год назад

Thanks for watching 😀

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

@zuhebkhan6973 Год назад

Thanks in advance

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

@itayhilel2168 Год назад

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

@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

@AnandDwivedi Год назад

U presentation skill is amazing

@HowtoPowerBI Год назад

so nice to hear that, thanks Anand! 😊

@szklydm Год назад

FanBAStic!

@crowl6 Год назад

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

@ericlee722 Год назад

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

@lijunchen Год назад

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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wTRrskQzAHk.html

@eldrigeampong8573 Год назад

Very informative video

@HowtoPowerBI Год назад

Great to hear that, thanks Eldrige

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

@philc787 Год назад

Great content. Great beard too

@kumarvg5383 Год назад

Superb content 👌 👏 👍

@HowtoPowerBI Год назад

Thank you Kumar 😀

@abdulrahmanbaamer8624 Год назад

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

@SolidSnake59 Год назад

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

@gersafriyie Год назад

That's great BAS

@HowtoPowerBI Год назад

thank you Afriyie! 😊

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

@andreanikitacavaletti9761 Год назад

great

@yueyin6071 Год назад

wow superb creative guru

@HowtoPowerBI Год назад

Thanks 😊

@MrBasu-iq6md Год назад

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

@ketanshah1389 11 месяцев назад

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

@juanignacioXI Год назад

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

@florianpieront3296 Год назад

You are the Power BI GOAT 🐐🐐🐐

@HowtoPowerBI Год назад

Haha :) thx!

@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

@RAM-nm2dx Год назад

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

@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 :)

@dnyaneshwarbirajdar9237 11 месяцев назад

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.

@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

@leoncastro3073 Год назад

TOP

@HowtoPowerBI Год назад

thanks Leon!

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

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

@rodrigorodriguezpaulino7856 Год назад

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

@disconnect7401 Год назад

👍👍👍

@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

@muzniahamed5887 Год назад

How to incert new row in power query

@TBGM855 Год назад

Can you create a strategy map like this?

@legendgod 9 месяцев назад

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

@HowtoPowerBI 9 месяцев назад

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

@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

@rabe3dam188 Год назад

Wooow

@HowtoPowerBI Год назад

😎🙂

@user-rv2kw5ez3l Год назад

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

@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

@henripasaribu2467 Год назад

How to view pdf file on Power BI ?

@zuhebkhan6973 Год назад

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

@HaoCui-up1dp Месяц назад

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

@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

@geekybutton2589 Год назад

" Bas , the PowerBI scientist"

@HowtoPowerBI Год назад

Lol 😀 indeed took a bit of experimenting

@geekybutton2589 Год назад

@@HowtoPowerBI Man your experiments are making me grow a lot. Keep up those good works. 👍

@youjohnny16 Год назад

Your analysis brain is unique. So jealous.

@Baldur1005 Год назад

How you come up with this is beyond me. First you knew you want something like splitting the image, then thought about map visual, then new about some bizarre program that let you create maps in GeoJSON format and then to another one to convert it to TopoJSON... Come man it require serious IT knowledge and creativity ;)

@HowtoPowerBI Год назад

dzieki Artur :) took some digging but at one point it was crystal-clear it is possible :) took me some time to figure out the scaling trick

@sherifffruitfly Год назад

Good video, but the reality is it's workaround after workaround for a poorly implemented feature.

@HowtoPowerBI Год назад

thanks Chris! 😊in other tools doesn't work so much differently .. not so much of a workaround in my view - just the adjustment so that the projection is correct is a bit annoying. Maybe you prefer the custom visual synoptic (process would be similar though)