Power BI Data Visualization: Happy New Year Power Map Walkthrough

Power BI Data Visualization: Happy New Year Power Map Walkthrough


in this video we will see how that was done the data is quite simple first column country second column
time zone I removed the plus and minus signs now in order to plot the countries
we need the country name and in order to animated across the timezone so we need
a datetime value what we have here in time zone is just the offset from GMT
have converted that to a simple date time value by taking based date of 1st Jan 2016 adding the the midnight time to it which is Time 000 and then adding the offset here so the
first place where the time difference is plus 12 there is no offsets so it is 12 AM
and then it goes on and on in the last row which is 11 p.m. that is for the
last time zone which is minus eleven GMT If you are using Office 2013 you
will have to install Power Map as an add-in I’m using Office 2016 so Power Map is
already installed it’s a part of the native product it’s now called 3d map
instead of Power Map is what happens it shows me a 3d map and it has already
plotted all the countries on top of them and by default it doesn’t show you
map labels but you can enable from here I’m going to use a different theme so that we
can see the entire satellite map of course the countries are plotted in different colors so you may not be able to see them clearly but that’s ok what we really wanted to
see the entire map because it’s a globe can see only half of it so one way of handling that is to create a flat map now what we really need to show is which
country is going to have sunrise as the timezone progresses now here countries are identified using the
just a dot but I want to identify the entire region of the country and that is
done by just clicking on this button and notice that all the country got glittered
almost at the same time but we want to show the time progression
based on the time zone and for that purpose we need to animate the time
portion of this when you open the time fields it only shows your date time type of data the only one
column of that once you do that you get something here what is this this is the
last date time by which we saw you know I did at 11 p.m. I’m not really interested in
the time portions are going to edit the format and keep just the date portion and we’ll adjust it in such a way that this is clearly visible all the
time on the map I also want to get a quick opinion message which is just a text box and now when I run this was going to
happen is it’s going to take seconds but I want to do it in six runs too lengthy
and click on the play button and I what happens is going to actually go as part
time zone and keeping lighting each country and that’s how we could actually
show the year progressing across time zones but I also want to show the same
thing on a 3d globe this was a flat map I want to keep this as it is going to
create a new scene you seen essentially copies everything from the previous
scene which is good but in this case we want to convert to a globe and I want
to light it from time zone here which is almost + 12 up to here which is India around 5.3 from GMT
harder to that of course I can click on play and it’s going to do exactly the same thing but
notice here that even though I’m not seeing the rest of the globe it going to pot it and it is going to take its own time to do it I don’t want that I want to
show only this part of the globe but I want to force Power Map only to plot those countries
and that is done by using filters so we’ll add a filter. Now Diff contains our timezone
when I click there it actually shows me my range from minus eleven GMT to + 12 GMT well I know I need to start from + 12 and end somewhere 5.3
which is India in their orders it is doing the job correctly and now let’s play and
it’s going to do exactly what we wanted started from there and going to go all
the way up to India and the project for this month six seconds is a bit too much
certainly really is this to 4 seconds and let’s try again I’m just going to rotate it in such a way
that New Zealand is also seeing and that should be the best way to show it right
now so once scene is done then we’ll get the globe in increments and show the rest of
the world now we’ll add one more scene rotate the globe in such a way that India is
this side now and of course change our filters ending point will be 5.30 is starting
to move this around endpoint is somewhere around 5:30 I
don’t want to show India’s should be a little on the other side of so this is
my second scene we will add one more scene now and in this scene we will use
mouse to rotate again and then show the rest of the way back to the filter move the filter
all the way from one point or whether it was and you should be good to go and
the many play this part is going to be shown in four seconds from now if you
play the entire tool its going to look like this notice that there is a smooth transition wile we are moving from one
scene to order which is a nice take care of those double the speed of animation
and amount of time it takes for transition and that’s how it is done
thank you and Happy New Year to you

Related Posts

I Tested The RAREST Paint Colors To Ever Exist…
Kim Kardashian | Draw My Life
How To Draw Earth Day pictures | World Earth Day | Save Earth Images For Drawing Competition

How To Draw Earth Day pictures | World Earth Day | Save Earth Images For Drawing Competition

How To Draw Earth Day pictures | World Earth Day | Save Earth Images For Drawing Competition

3 Replies to “Power BI Data Visualization: Happy New Year Power Map Walkthrough”

Leave a Reply

Your email address will not be published. Required fields are marked *