Creating Map Small Multiples In Power BI With The Azure Maps API

Since my post last week on using the Google Image Charts API to create sparklines and small multiples in Power BI has proved very popular, I thought I would do a follow-up showing how to use the Azure Maps API to create map small multiples. Here’s an example of what’s possible, a table from a sample report I built that displays crimes committed in London (sourced from here) in June 2018 with one row for each crime and a map column displaying the location of the crime:

Bron : Chris Webb’s BI Blog
Lees meer…

Creating Sparklines And Small Multiples In Power BI Using The Google Image Charts API

The excellent work that David Eldersveld has been doing recently on using SVG images in Power BI has generated a lot of interest; now that the August 2018 release of Power BI Desktop allows you to set data categories on measures – and specifically the Image URL data category – David has been able to apply his work to the creation of sparklines and small multiples in Power BI.

Bron : Chris Webb’s BI Blog
Lees meer…

Combining Data From Multiple Worksheets In The Same Excel Workbook Using Power BI

It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve found on the internet work in more complex scenarios when the data on each sheet needs some kind of transformation before it can be combined.

Bron : Chris Webb’s BI Blog
Lees meer…

Change multiple Application Area tags with PowerShell

Before you convert an existing Dynamics NAV solution to an extension written in AL, the ApplicationArea property must be set on all your custom controls. Otherwise, they will not be visible.

Setting the ApplicationArea property one by one is a tedious task that can be partially automated with the following PowerShell scripts:

Bron : Dynamics NAV Team Blog
Lees meer…

How to Create Functionality to Attach Multiple Files to Records in NAV

In the Stock Exchange Bookkeeping App I wanted to be able to attach multiple files (ex: PDFs) to BVB Entries.

The attachments are files received from the brokerage firm and they refer to a transaction. For example, if I buy 1 stock, I will have 3 BVB Entries with the same Transaction Number. If I attach files, they will be linked to the Transaction Number and visible as below, in a Factbox, for all BVB Entries with the same Transaction Number:

Bron : Andrei Lungu
Lees meer…

Split multiple columns into rows in #PowerQuery

Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always turns out to be a difficult task than I first assumed. On top of that, with this particular data source; data was coming as semicolon delimited text. Basically, there were many columns like Mile Stones and Sub Milestones, their related data and so on.

Bron : Prathy’s Blog
Lees meer…