-
This is very easy in Power BI, however it is not so obvious in Report Builder and a lot of online tutorials send you down the garden path. Some will tell you to do the Top N filter on the dataset. However this presents problems: To filter Top N on a chart, click the chart,…
-
There is allegedly a Hubspot connector for Power BI however I have never got it to work. Even if it does I suspect it would not allow access to deal line items which are buried deep in the Hubspot API. Deal line items are when you create a Deal and add Products which may be…
-
I have two postcodes in two columns in Excel. I want the distance between the two in a third column. There are a couple of approaches. One could try and get the longitude and latitude from the postcodes and then calculate an as-the-crow-flies distance mathematically. You could try pasting them into co-pilot and asking it…
-
Freshly back at my desk after a week of wandering around the countryside and swimming in the sea, the thought occurred, “Do I really need to be here? Why haven’t I been replaced by a robot yet?”. After all, we have been promised that artificial general intelligence (AGI) is around the corner for some years…
-
Testing some multiple choice questions, I came across an issue that seems curiously little discussed in education circles. The case is the multi-select, multiple choice question, where a learner may select x number of correct answers from y number of options. The client particularly did not want to divulge how many correct answers there were,…
-
How to make shape maps in Power BI for the UK (or anywhere) Out of the box, Power BI seems to offer a pretty good selection of map visuals… until you try and apply them to the UK. Power BI sort-of recognises UK postcodes, but it’s no good with counties. Anyone who starts trying to…
-
Maps in Power BI can be confusing. The fist map visual in the list looks pretty good: But if you use this Power BI will pester you to upgrade to Azure maps. Azure maps looks like this: There are differences between the available bubble sizes in these visuals but that’s about it. There are some…
-
Most demonstrations of using as an excel sheet as a datasource for Power BI will assume the excel sheet is locally stored. This is what happens when you click Get Data and Excel in Power BI desktop. Eventually you will want to have this auto refreshing and in order to do this you could install…
