@@LondonBusinessAnalyticsGroup haha - honestly, the videos you produce and the material are stellar. I owe you more than a few pints once Lockdown ends...
I didn't know that Bing maps could plot with UK post codes; Ive been mapping to latitude and longitude: good tip. Something that may be useful to the community is the Excel formulas I developed to decompose UK postcodes into the their Area, District, Sector and Unit sub-components: Area : =IF(ISNUMBER(VALUE(MID([@Postcode],2,1))),LEFT([@Postcode],1),LEFT([@Postcode],2)) District: = IF(FIND(" ",[@Postcode])=3,MID([@Postcode],2,1),IF(FIND(" ",[@Postcode])=5,MID([@Postcode],3,2),IF(ISNUMBER(VALUE(MID([@Postcode],2,1))),MID([@Postcode],2,2),MID([@Postcode],3,1)))) Sector: =MID(RIGHT([@Postcode],3),1,1) Unit: =MID(RIGHT([@Postcode],3),2,2)
Hi can someone help me, what i'm trying to do is. e.g i have 5 drivers. each time they stop it generates a location on the map. i want to join the dots up on the map to create a route they took for each driver i am able to plot the different location on the map and group them in different colours per driver but i can't see and option to join them up also with an indication of what way they are going. anyone able to help me please?
![NLE Choppa - Or What ft. 41 (Orchestra Mix) [Official Music Video]](http://i.ytimg.com/vi/biOFASEgSOM/mqdefault.jpg)
![Power BI Maps [Tips and Tricks]](/img/1.gif)
There's some really useful information here. Many thanks for taking the time to put it together, excellent tutorial.
Absolute class! You deserve a Nobel Prize.
Thanks Amarvir! I'll take the $100K that goes with it also;-) - Mark
@@LondonBusinessAnalyticsGroup haha - honestly, the videos you produce and the material are stellar. I owe you more than a few pints once Lockdown ends...
Excellent summary again Mark. Thanks
Thanks Paul, we will be continuing the weekly possibly to the end of the year. - Mark
Thank you for this video!
Hi Brendan, Glad you enjoyed it. - Mark
I didn't know that Bing maps could plot with UK post codes; Ive been mapping to latitude and longitude: good tip. Something that may be useful to the community is the Excel formulas I developed to decompose UK postcodes into the their Area, District, Sector and Unit sub-components:
Area : =IF(ISNUMBER(VALUE(MID([@Postcode],2,1))),LEFT([@Postcode],1),LEFT([@Postcode],2))
District: = IF(FIND(" ",[@Postcode])=3,MID([@Postcode],2,1),IF(FIND(" ",[@Postcode])=5,MID([@Postcode],3,2),IF(ISNUMBER(VALUE(MID([@Postcode],2,1))),MID([@Postcode],2,2),MID([@Postcode],3,1))))
Sector: =MID(RIGHT([@Postcode],3),1,1)
Unit: =MID(RIGHT([@Postcode],3),2,2)
Thanks Graeme, these are very useful. - Mark
Loving your videos! Around 4:50, why do you create a measure to count the rows rather than using the built in count feature?
Hello Mark, Currently learning power bi. how do i create a similar table as yours with the graphs on the table. I like what im seeing.
HI Deborah, best to download the Power BI file and look inside to see how the features you like are built. - Mark
Very good
Thanks
Hi
can someone help me, what i'm trying to do is.
e.g
i have 5 drivers.
each time they stop it generates a location on the map.
i want to join the dots up on the map to create a route they took for each driver
i am able to plot the different location on the map and group them in different colours per driver but i can't see and option to join them up also with an indication of what way they are going.
anyone able to help me please?
Hi Mark, can I create a heatmap in PowerBI with a list of all my co-ordinates?
Hi SG, Depends exactly what you mean by a heat map;-). The Mapbox custom visual has some good features for show density distributions. Marrk
Thanks Mark
No worries