Learn how to create STUNNING maps in Power Bi | Gartner remake

so hello everybody and welcome to another power bi video in today's video we're going to talk about report design one of my favorite favorite topics okay so the pyruvate team participated in the gardner summit on europe and created this beauty um everybody was crazy about the map obviously it is the focal point of this design so understandably so so we're going to recreate it you're going to see what it takes to actually do this let's get started okay ladies and gentlemen before i start the most important thing of all if you see a design that you like you need to replicate it it's not enough to just look and see oh it is a shape map because there's always so much more and the beauty of things always hides the detail i don't know why but it is what it is so it's not enough to see that this is a shape map you have to go through all the details so i actually rebuilt the entire thing with a data set that i know and was curious about how it looked with this design and that's when you actually see the amount of work that it took to create that thing i obviously super simplify it and reasons to the madness but anyhow i'm going to show you how it looks for them it's just crazy look at that all these things it's just for page one it's like layer up layer of shadows and uh crazy but we're going to focus on the map because i think that's the one that requires perhaps most explanation of all so let's go let's not waste more time what i'm going to do is duplicate this page because we're going to butcher this so first of all the map let's click on the map and then you'll see that the map is a country code and access to electricity per cent of population esc data right so we're going to on a new page i'm going to actually change the background so it's white so you can actually see if well i should probably not do that i'm not going to do that i'll tell you why in a second so we're going to look for country i really really recommend you that you recreate it with a data set that you like it just makes all the difference in the world to actually learn how somebody did something and then is the percentage of population thank you very much and then this is a shape map so shape map you need to have it it is a preview feature since 2040. so you need to enable it the preview feature and then once you have it you need to go to shape and they created a custom shape for that which is nuts so download the report and steal it okay and then the projection is orthographic projection and as you can see it starts to look kind of similar let's add the continent filter that they had and we're going to put it like that this is the theme that makes things look a little bit crazy but don't worry about that and then you start clicking on it and you see that it's not doing you know the cool simulations and stuff that you had on the original one to the original one where you actually select something you just yeah so why well that's what i mean you need to actually recreate things in order to be able how they work the reason for that is let me show you so we're going to pick our map visualizations you probably wonder what do you have the old format pane here's the thing the properties on the shape map were not moved to the new format they they were not and not only that there are a ton of formatting options that were used in this report not for previous visuals that are not on the new format pane i was actually very very surprised and you know after a lot of back and forth they said like okay all for my pain it needs to be updated it was not cool one of the things like i was because i know you know i just jason theme template so i know a lot of the features i know i was going crazy because i know that you can do this but i couldn't find it on the new format page so i hope to fix that very very soon because she's so confusing anyhow assume how to zoom and then you start getting the f look at that how pretty okay now what is the difference as you can see this thing is on a square and his map is not on a square or is it well if you look at it it doesn't look like a square like where where are the borders where is there and that's where the madness again comes so beautifully done so if we go to the selection pane they're going to see that i have a layers called map and here you have obviously the shape map which is the actual visualization map visualization but then you have three other shapes let me show you the first one on this one i wanted to have the white so you see we're going to create a new page for that i'm going to create a new page i'm going to get rid of the background so it's a white background we need to see these and then this is the layer that sits on top of the map do you see what i thought they were doing that with a photoshop or something but they cannot do that realize it afterwards and that's again you need to recreate this yourself the reason why i cannot do i couldn't or they couldn't do it in photoshop and i couldn't do it because i was putting everything on the background image is that it's going to lay the map if you look at it it lays on behind all the stuff now they have layered everything in power bi so there's no problem they can't hide it did everything in photoshop so all these elements are photoshop everything i can show you very quickly if i turn you see everything behind is a photoshop thing so i cannot lay that shadow thing on front because otherwise it's going to lay it on top of these but i actually thought it was quite pretty to have the map going on these sections here because for the first one you want to see you know these parts of america that's why this map for business purposes is not very good but anyway if you're just doing a show or you're just you know showcasing paria is super cool and i really like the fact that it just goes a little bit into the other visualization so people will hail it i thought it was cool so i did not want to have this extra layer on top of it but i can see what they will have it and it just makes all the difference of the world now if we move this in here just do you see how it starts to disappear a little bit obviously a little bit more work is required on here so we're going to get rid of the title we're going to read the background the border no shadow they had a tooltip so let's keep it and now it's integrating better in the background and look when i put this in you see how it just starts to fade away but it still looks like square like look at it it's a square and it doesn't look like a square on his mouth and the reason why it doesn't look like a square is because of the other two layers that they put in with cheese let me grab there's just stuff everywhere not sure exactly which i'm grabbing so let's do it here so that one i don't want exactly so this is the one i want to copy and i'm going to go here and paste it so these helps melt the corners of the shape map and not only that because that is that alone is just not enough you still see this the squares if we go back to here and we open the map and then we grab the next layer put in there and then we're going to put that in the back right okay so now you need to start framing these sorry let's grab the map and we need to am i grabbing the map no because this is still on there let me send this to the back now it should be grabbing the map maybe no it's still not map where is my map it's maybe that one no that one this is the shape okay so if you grab the map and now it starts to what i saw when i start playing with this is that if you frame it in the white space and then you put this thing on top you see that it's not really so you have to play with it until you find where the proper send it to back go back and then let's grab our map and then you can just you see how these colors blend and how those colors blend see you've got to play with it until you actually start moving things and you get the illusion look you get the illusion of a circle moving and you can spend as much time as you want to be careful with that i mean there's no point of spending way too much time but anyhow you see how beautiful it was done and you see what it took to create which is absolutely crazy they would go back very quickly and look at other elements i mean it was actually very very neat design this thing here so they have one for the continent and i thought it was so pretty that it didn't have a multi-layer slicers i don't particularly like multi-layer slicers so this is quite good because you pick a country this beautiful thing moves and then here you have all the countries all the information for the country's disease a small multiple laid as one chart at a time wonderful use of space and also you don't need to have so many charts on top these they've used it already for the uh for the other report last year i don't know what it was it was poverty or something and it's basically the slicer is speaking a year one to one and instead of filtering it's just highlighting you can see and i've shown you previously how to do these things you can see all the details here so i truly recommend you to reproduce and recreate it yourself super annoying thing that still is here because the shape map is non-previous there are no well there are no legends in any maps which is except obviously for the ashore one and the professional ones map box and stuff but these is made just of elements like that and this is that's not that's not okay in my book maps should have a legend and it should be the legend should be color according to the values of the map not just kind of but it doesn't have a legend so it is still in preview and if we go here to the next page i recreated also the bubble chart uh it is a logarithmic scale that's what it threw me off and again you have to create it to know so i think you should somehow you should be highlighting the disa logarithmic scale because you maybe could because of the shape of the data thing that it could be but not everybody will get that and this is a beautiful design matrix then you have the you you know the typical stuff that they put on this the aya stuff so the um key influencers and yeah i really really truly recommend you to recreate this with a data set that you like don't use this data set use another dataset so you can actually go full-blown onto what would you like to see and how would your data look in this template so really really cool i think it did a wonderful job but it was a little bit painful to do just because you know i was fighting back and forth between the new pain and the old pain because i thought it was just a shape map that didn't have the properties unfortunately it was more than that it was other visuals that were missing important for properties for conditional formatting and there are no legends you know that you know what i think already so let's not hammer it in anymore do it that's all i can say and i will see you again on thursday with a another cool video hopefully so see you soon bye

Channel: Curbal

Views: 50,856

Keywords: Power bi, powerbi, Curbal, power bi desktop, power bi tutorial, power bi training, power bi for beginners, ruth pozuelo, gartner remake power bi, stunning maps in power bi, shape maps in power bi

Id: OQuKwy6eEDk

Length: 14min 57sec (897 seconds)

Published: Tue Jun 07 2022