Overview

Introduction Kerry Kolosko created an excellent article about the embedding of HTML content into Power BI. All sorts of content can be embedded within HTML Content custom visual, but the most interesting are Google Charts and Vega-Lite. Both of these visualization libraries offer a rich gallery of interactive charts that... [Read More]

Introduction Hierarchy is a very useful funcion in Qlik Sense, that can transform a parent-child hierarchy table. A similar funcionality can be replicated with a recursive CTE in T-SQL. A hierarchy where a child node has a single parent can also be transformed using Parent and Child functions, such as... [Read More]

Introduction The Power BI report and Power Query M code demonstrates how to split time data into days and shifts. In the example provided, the data is split into 3 shifts and each day starts at 6am. This ensures that data, such as duration between start and end times, is... [Read More]